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"/>
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?
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.
Hello Randy and all Flexmonster users,
We would like to inform you that this feature is available starting from the version 2.3.
@Tanya: thanks for the improvement and the notification of the update!
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?”
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.