How do I hide the "All" member in a dimension


I am working with SQL Server Analysis Services (SSAS) 2005.

I have created a simple dimension that presents a short list of dates.  The dimension works, but includes an automatically generated ALL member.

I am trying to figure out how to eliminate the All member from the dimension.  How do I do this?

LVL 13
Who is Participating?
agandauConnect With a Mentor Commented:
Go back to the dimension structure tab, and select that attribute.

Go to the properties and find "IsAggregatable" and set it to false.  You'll have to re-deploy and reprocess the dimension to check out the results.

Hope this helps.
bobsegrestAuthor Commented:
Thank You agandau,

That is just what I was looking for.

Bob Segrest
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.