SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSAS – Changing the Dimension ALL Member Name

All Analysis Services dimensions have a default All member that represents all the members for a particular attribute.  For example, let’s say you have a product dimension with an attribute for the product name.  This attribute will be given an All member that represents every product.  The All member has many uses but one example is it can be used when writing MDX for things like percentages.  The screen shot below shows how it is represented in the dimension browser of BIDS.

What I want to quickly show you is how you can optionally change the name of the All member.  If you select the dimension name on the Dimension Structure tab and open the properties menu (F4) you will find a property called AttributeAllMemberName. 

When you change this property to let’s say All Products it will then apply to the All member the next time you process.  Just a quick tip if you ever had the desire to change the name from All to something of your choosing.

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


No comments.

Leave a Comment

Please register or log in to leave a comment.