🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Viewing Second Level in Hierarchy

Randy Syring asked on June 16, 2016

I have a dimension defined in Mondrian as:

    <Dimension name="Payee" foreignKey="payee_id">
        <Hierarchy hasAll="true" allMemberName="All Payees" defaultMember="All Payees" primaryKey="payee_id">
            <Table name="residuals_dim_payees" schema="star"/>
            <Level name="State" column="state"/>
            <Level name="Name" column="name"/>

This shows up in FlexMonster as “Payee” but with the payee value being the State value.  I can then expand the state on each cell individually if desired.
However, in other tools like Saiku, I can pull the second level value, Name, and use it directly to get rows of names combined with a measure.  Is this possible with FlexMonster?

5 answers

Roman Petrusha Roman Petrusha Flexmonster June 16, 2016

This feature will be available in the next release 2.3 (ETA Sep 2016). We already have many requests for this feature from our customers. 

Tanya Gryshko Tanya Gryshko Flexmonster December 5, 2016

Hello Randy and all Flexmonster users,
We would like to inform you that this feature is available starting from the version 2.3.

Randy Syring December 5, 2016

@Tanya: thanks for the improvement and the notification of the update!

Randy Syring December 5, 2016

When a dimension is turned on for the report, I can drill down into the levels as I could before. In the dimension/measure selection box, I still see only the dimension name, without the ability to pick a specific level to show on the report. In terms of the demo at http://www.flexmonster.com/demos/connect-mondrian/, what we are looking for is the ability to have Product Department or Product Category (the sublevels) on the report without showing the top level. In your demos, I see that for MS Analysis Services a hierarchy can be expanded to select the sublevels – is this feature not enabled for the Mondrian source?”

Iryna Kulchytska Iryna Kulchytska Flexmonster December 6, 2016

Hi Randy,
The feature of picking a specific level to show on the report is available for Mondrian via XMLA. Here is a jsFiddle that is based on XMLA connection to Mondrian http://jsfiddle.net/flexmonster/Lowatxw8/
Our demo on the website is based on Accelerator for Mondrian. This feature is not available in Accelerator for Mondrian yet.
Could you please let us know if the connection via XMLA works for you?
We will inform you when the feature become available in Accelerator for Mondrian.
Kind regards,

Please login or Register to Submit Answer