SQL Server Analysis Services – Setting the Default Measure for the cube

Hi Friends,

This is indeed so basic and simple and I got surprised when I observed during one of my assignments that the customer has not set a default measure for the cube; they just did not know about this option. Since when you browse the cube, a default measure is picked up automatically and that suits the requirement of the client 🙂 But what if you want a different measure to pop up by default?
This is where you set the default measure for the cube:



As per the documentation the SQL Server Analysis Services may pick up any measure as the default measure if one is not set (I generally see it picks up the first measure). In the above example, Total Sales could be a good default measure and gets picked up automatically being the first measure in the measure group. But what if you wanted Unit Sales to be the default measure; then, you need to set this explicitly.

Yes, I know simple stuff, but I still see customers ignoring this 🙂 or not knowing about this.




About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published.