Report Portal

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

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)

 

Tags: faq, management, security, drillthrough

 

2007-2015 VidasSoft Systems Inc.