Microsoft KB Archive/933032

= How to hide a dimension name when no members are visible for a security role in SQL Server 2005 Analysis Services =

Article ID: 933032

Article Last Modified on 4/3/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



INTRODUCTION
This article describes how to hide a dimension name when no members of a specific security role are visible in Microsoft SQL Server 2005 Analysis Services.



MORE INFORMATION
In SQL Server 2005 Analysis Services, you cannot hide a dimension name. Even if no members are visible for a security role, users can still access the dimension name by using the Multidimensional Expressions MDX (MDX) statement.

When the dimension members are protected by security roles, the users whom the setting affects can see only the members whom the users have permission to access. You may want to hide the whole dimension so that the dimension name is not visible for a specific role.

If you want to hide the whole dimension, you must create a separate cube for each role that needs this feature. The cube contains linked measure groups. The cube does not include the dimensions that you want to hide.

Note You must create a cube for each role that needs this feature. For example, if you have 10 roles and need to hide a different set of dimension names, you must create 10 cubes.

This feature cannot be implemented in a simple design change. Therefore, this feature may be included in the next release of SQL Server Analysis Services.

Keywords: kbhowto kbsql2005as kbexpertiseadvanced kbinfo KB933032

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.