Display Folders from Tabular Model
Hello,
I am looking at using Display folders to make measure navigation easier for users.
However, when I put a couple of measures in a display folder, Pyramid seems to then to lose the ability to group measures by table, and only uses these new folders.
This is different to how every other method of viewing tabular data behaves (Power BI, excel, SSMS etc.) as these keep the table folders and then the display folders are sub-folders under these.
Is there a setting I need to change to make Pyramid behave like other software?
Thanks,
Alec
3 replies
-
First, display folders are designed to let you group and sub-group measures as needed. This is their actual role - and its how it's used in Pyramid.
Measure groups are not an organization tool - despite the fact that many other tools blend the 2 features together. This actually makes it difficult for users to build their preferred organization of their measures, since they will always need to have to interrogate the structure with measure groups whether they like it or not. This often results in measures - in a common display group - being split across multiple different measure group folders. And vice versa. This is ultimately far from optimal. (Regardless, there is nothing preventing you from adding measure groups as display folders into the display structure if you really want them).
However, Pyramid does expose measure groups for the benefit of limiting or filtering the meta structure to relevant hierarchies and measures. You can see it below in the image. This gives you the best of both worlds. And it turns out that we are using the two capabilities the way they were intended!
-
Hi Avi,
The above makes sense, and we are going to be making use of this flexibility, however, I have just tried adding a single measure to multiple folders and it isn't working as I would expect.
This is possible in SSAS using a semi-colon, and it will create multiple versions of the item in different display folders. See attached example, O Net Sales incl VAT LY WTD LFL, which I want to display in a LY folder, a WTD Folder and a LFL folder which works in SSAS.
I did this by assigning the following text to display folder: Sales\Ordered\Net\Sales incl VAT\LY;Sales\Ordered\Net\Sales incl VAT\LFL;Sales\Ordered\Net\Sales incl VAT\WTD
But, when I pull it though to Pyramid, it doesn't seem to recognise the semicolon as a split, and instead just creates a really long folder structure with just the \ denoting separate folders.
Thanks,
Alec
-
We don't support multiple folders (I'm not sure why you would want to). Use one only.
