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.