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

How the transformed data is written to an output file with column headers in U-SQL...

While working with U-SQL language, I noticed that there are few ways of writing data to an output file. Let's assume the SalesDetails....