I’ve already blogged three times on measure groups matters and never thought I would have enough material for a fourth blog post. Fact is I stumble across an old post from Mosha Pasumansky on his sqlblog blog on the topic and rediscovered something I almost forgot with the years.
First you can find the three first posts here, although you’re not required to read them first to get the point of this post :
To sum up Mosha’s blog post, you can add some extra flavour to your measures organization into folders with the following techniques :
– You already know that you can organize your measures into folders. But it is less known that you can have also sub folders. For doing this, as the UI in BIDS does not seem to allow you to do it, you jus have to enter the folders located on the path to the indicator separated by a “\” or “/” sign depending on your client tool. (ie : “folder 1\folder 2\…\folder x”)
– Even better, you can specify multiple folders to host the same measure by separating them with a “;” sign. (ie : “folder 1;folder 2;…;folder x”). In this case the measure will appear as much as the number of folders but it will act as one and single measure as selecting or de-selecting one of the clone will automatically impact the other instances.
Note : All those behaviors are client tool dependant as the information are only metadata attached to each measure and as nothing requires the client tool to make use of it. So depending on which tool you’re using, you may have to test its behavior before proposing those mechanism to you end users. I have tested them with success in Excel 2010.