Drilldown

Is there a way to disable a level drill down? I want to keep the level set to All and not have the user to drill down via the report.

One possibility is to try custom dimension security:

http://msdn2.microsoft.com/en-us/library/ms175366.aspx

>>

SQL Server 2005 Books Online

Granting Custom Access to Dimension Data

After a Microsoft SQL Server 2005 Analysis Services (SSAS) database role has read or read/write permission to a dimension, you can define security on each dimension member (also called dimension security). By default, a database role is not allowed access to any members of any dimension. You have to grant permission to allow access to specific attributes and attribute members within the dimension. The properties that are available for viewing attributes and attribute members are: IsAllowed, AllowedSet, DeniedSet, ApplyDenied, VisualTotals, and DefaultMember. The type of access that members of a dimension role have is based on the dimension access granted, either read or read/write.

>>

|||

I'm following the BOL, but I don't see the "Dimension Custom Data Access" option in the "Select a page pane" when editing the Analysis Service database role. Is this only available in a specific version/edition of SSAS? I'm running Developers edition w/ SP1 installed.

Thanks.