Hi Anthony,

I'm not sure I understand what you mean. If you are using a Regular Hierarchy you can drill up / down, expand down etc. to show whatever levels you want from the hierarchy.

Can you show visually what you require?

Thanks,

Ian

To add to what Anthony has described above, it's not possible to do only when we use the MSAS Cube, but not in the case of IMDBs.

So the context here is, to make it possible to show each level of a 'multi-level hierarchy' from the 'cube' to also show separately in the rows/columns adjacently (like we do with 'regular hierarchy' and 'drill-path hierarchy' in the case of IMDB). Hope the requirement is clear now.

Hi guys,

Regular Hierarchies defined in Pyramid behave the same as hierarchies defined in a SSAS cube, in that as you drill up and down, the column remains the same (the hierarchy name).

In a Pyramid Regular Hierarchy, same as in a SSAS cube, the hierarchy levels are composed of attributes from that dimension. If the attributes are visible to the user as well as the hierarchy, then you can place them side by side as you describe.

Other analytic tools, like Power BI and Tableau for example, allow you to place the levels of a hierarchy side by side only because they cannot handle and manage a hierarchy properly as they were designed to be used and cannot expand down / drill down / up within the same column or row.

To get what you want now, without asking for Pyramid to change how it handles SSAS or Regular Pyramid hierarchies, simply ask your SSAS cube designer to make the individual attributes that make up your SSAS cube hierarchies visible to the users. You can then use the hierarchy levels individually, exactly as you wish to in your description above.

That will be much the quickest solution and one entirely within your own control. It is extremely unlikely Pyramid will change how we handle Pyramid Regular or SSAS hierarchies.

Hope that helps.

Ian