Menu
Download Free Trial

Viewing Second Level in Hierarchy

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"/>
        </Hierarchy>
    </Dimension>

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

Public
Roman Petrusha Flexmonster June 16, 2016

Hi!
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. 
Regards,
   Roman

Public
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.
Regards,
Tanya

Public
Randy Syring December 5, 2016

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

Public
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?”

Public
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,
Iryna
 

Please login or Register to Submit Answer