SSAS -> How do you hide an attribute that is used in a hierarchy? (without using perspectives)

sql sql-server tsql sql-server-2012 ssas
Bill Blankenship picture Bill Blankenship · Feb 11, 2012 · Viewed 7k times · Source

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)

Answer

Bill Blankenship picture Bill Blankenship · Feb 15, 2012

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.

Related questions

Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Read More
Sequence vs identity

SQL Server 2012 introduced Sequence as a new feature, same as in Oracle and Postgres. Where sequences are preferred over identities? And why do we need sequences?

Read More
Scope of temporary tables in SQL Server

I wrote a stored procedure to import and transform data from one database to another. Each import would take a single company ID and import all data related to this company. To help with the transformation step I use temporary …

Read More