Thursday, July 10, 2014

Set the Visibility of a Dimension Hierarchy in SSAS...

In some scenarios, you may need to set the visibility of a dimension hierarchy as hidden. Because that hierarchy may be used for some of the calculation and it is not good to show that to the user.
In such a case, it can be done using the below steps.

  • Open the Cube available in the BIDS.
  • Then select the Dimension Hierarchy available in the Cube Structure tab.
  • Right click on it and select Properties.
  • It will open the Properties window and set the Visible property value to False.
  • Then deploy and process the Cube. When the cube is browsed, that dimension hierarchy will not be visible.

No comments:

Post a Comment