Using a Display Folder for a SSAS calculation
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will only work if you select “Measures” as the Parent hierarchy:
The display folder (“Acct Calc – Supply Chain”) shows up correctly when browsing the cube, under “Measures”:
However, if you select something other than “Measures” as the Parent hierarchy, in this example the “SupplyChain” hierarchy under the “Account” dimension:
The display folder does not show up. Instead, the calculation appears under “Members” under the “SupplyChain” hierarchy under the “Account” dimension:
Of course, you should only use “Measures” as the parent hierarchy if you want to define a calculated measure. If you are creating a calculated member, then you should select a dimension and hierarchy in the selected cube for the “Parent hierarchy”. It would be nice if a future version of SSAS allowed you to create a folder for calculated members. See the discussion Display folders for calculated members for work-arounds.
Note that this applies to the following client tools: SSAS internal browser, ProClarity, and Excel. There are some client tools that may support the display folder for calculated members.
James, I agree with you this would be a terrific improvement to the next version of SSAS. Here’s a Connect item I found recently on it, if you want to vote for it: http://connect.microsoft.com/SQLServer/feedback/details/663210/no-display-folder-translations-on-the-calculated-members
Thanks for the great blog. (You’ve been posting some things recently that are really different – and really informative.)
Melissa
Thanks for the Connect item Melissa, I did not know it existed. And glad you like my blog!