How do you set Analysis Services 2005 drillthrough security on the cube?
User Rating: / 5
PoorBest 
Written by Vidas Matelis   
Tuesday, 11 September 2007 19:32

Q: How do you set Analysis Services 2005 drillthrough security on the cube ?

A: In Analysis Services 2005 drillthrough security is set at the cube level. In the role definition go to "Cubes" tab and for each cube change attribute "Local Cube/Drillthrough Access". Attribute options are:

  • None (default)
  • Drillthrough
  • Drillthrough and Local Cube

Save role and deploy changes.

If you will try to execute drillthrough when you do not have proper permissions, you will get following error message:

The selected action cannot be completed because of the following error.
The permission required for this operation has not been granted.
This error may have occurred because the definition for the action is not valid. Verify the definition using the Actions view.
------------------------------
ADDITIONAL INFORMATION:
The permission required for this operation has not been granted. (Microsoft SQL Server 2005 Analysis Services)

 

< Prev   Next >
 

 

Pyramid Analytics