Posts Tagged BIDS

Analysis Services : How to break distinct count measures into separate measure groups ?

Having blogged last week here about the advantages of the new storage file format found in the Denali’s CTP3 for those kind of measures when they are of the string data type, remember me that maybe this little feature may need a post. This is no rocket science, just a little tip that every one would solve after spending 5 minutes on it. I even think that most of you may already know about it….

Read the rest of this entry »

Advertisements

Comments (2)

Analysis Services Feature Suggestion : Managing Measure Group visibility

The most commonly used reporting tool by the users to query Analysis Services may surely be Excel. As professionals, while testing SSAS solutions, we also add BIDS and SSMS to the list.

One of the great but little known feature of those SSAS reporting tool, is their ability to hide the multiple measure groups complexity by selecting one of them and only displaying the measures and dimensions that belongs to it.

Just in case you don’t know what I’m talking about, here’s a screenshot :

Read the rest of this entry »

Comments (1)