Hide Hierarchy levels under Granularity level in Role-Played Dimension

db_developer

Rate me:

0.00/5 (No votes)

11 May 2010CPOL

8.1K

There is no way to show hierarchy level in one dimension of one cube and to hide that hierarchy level in the same dimension (role-played dimension) of the same or other cube. Solution is to add additional hierarchy without levels to hide to this dimension.For example,There is dimension...

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

db_developer

Database Developer Freelancer

Ukraine

MS SQL Server Database Developer with 7+ years experience

Technologies/languages: Business Intelligence, SQL, MDX, VBA, SQL Server, Analysis Services (SSAS), Reporting services (SSRS), Integration Services (SSIS), DataWarehouse.
Also: economic background.

Feel free to contact me for rates and details.

Hide Hierarchy levels under Granularity level in Role-Played Dimension

Views

License

Comments and Discussions