Menu
I have some attributes that I am using to build hierarchies....(go figure).....after these attributes have been included in the hierarchy due to the change that I have made in their key columns they are no longer of use to an end user. If that doesn't make sense you probably don't know the answer to this question. (basically it splices the data by key columns included)
862
In the Properties window, set the value of the AttributeHierarchyEnabled property to False for the selected attributes.
A hierarchy is a useful tool in SSAS to reduce complexity. In the last article, I have created a cube now we learn about dimensional hierarchy. Firstly we create a supplier table in SQL Server also give foreign key relationship with the fact table.
The key attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact table. Typically, the key attribute represents the primary key column or columns in the dimension table.
You can create a hierarchy by using the columns and table context menu. When you create a hierarchy, a new parent level displays with selected columns as child levels.
Go to dimension tab, right click on your attribute. Set the attributehierarchyvisible to false. This will stop your attribute from being visible to your enduser and it will not be seen in the cubebrowser either.
160
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
