asked on July 11, 2019
Hi,
I've this dimension defined in my mondrian 4 xml file:
<Dimension name='Customers' table='USERS' key='customer_id'>
<Attributes>
<Attribute name='state' keyColumn='STATE' hasHierarchy='false' />
<Attribute name='customer_id' keyColumn='ID' nameColumn='NAME' hasHierarchy='false'/>
</Attributes>
<Hierarchies>
<Hierarchy name='state'>
<Level attribute='state' uniqueMembers='false'/>
<Level attribute='customer_id'/>
</Hierarchy>
</Hierarchies>
</Dimension>
I need to retrieve somehow the two levels "state" and "customer_id" (from the UI point of view the same highlighted in yellow in the attached screenshot), but i cant find any API to achieve this.
Am I missing something? Is there any API to retrieve this kind of data?
Thanks,
Davide
⋅ July 12, 2019
Hello,
Thank you for your question.
Could you please provide more details on your use case so that our team can suggest the best approach for your case?
We are looking forward to hearing from you.
Best Regards,
Vera
⋅ July 12, 2019
Sure:
the modal used to set colums, rows and measure does not fit with our company UI guidelines, so I'm trying to move out the configuration of the pivot table to the same "UI level" of the pivot table itself.
For a more detailed view please check the image in the attachment (sorry for the really bad quality).
Is that clear enought?
Thanks,
Davide
⋅ July 15, 2019
Hello, Davide,
Thank you for your quick reply and for providing more details.
We would like to inform you that it is possible to configure the Field List to be shown on the right instead of the pop-up window. Please consider the following example: https://jsfiddle.net/flexmonster/qmLuesxw/. Does it work for you?
Also, some additional CSS styles might be applied to the Field List. For example, here is a compact Field List: https://jsfiddle.net/flexmonster/rknvL123/.
In case you prefer to create your own Field List, we could extend getAllHierarchies() to return information about the hierarchy levels. Please let us know if this option seems more promising to you.
Regards,
Tanya
⋅ July 16, 2019
Hi Tanya,
thanks for the support, the shown example with the modal on the right is quite usefull.
But we'll prefer a more "programmatic" way in order to make component separation possibile on component oriented frameworks like React (which our company is using) and Angular.
If FlexMonster team is going to implement this feature, is there any approximate release date?
Thanks,
Davide
⋅ July 16, 2019
Hello, Davide,
Thank you for your answer.
Our development team will extend getAllHierarchies() to return information about the hierarchy levels and release this update on the 12th of August.
Please let us know in case of other questions.
Regards,
Tanya
⋅ August 15, 2019
Hello, Davide,
We are pleased to inform you that now getAllHierarchies() API call returns a list of levels if they are available.
Here is an example for illustration: http://jsfiddle.net/flexmonster/ux5kcsf9/
This is provided in the 2.7.12 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if everything works fine for you.
Best Regards,
Vera
⋅ August 19, 2019
Great,
thanks for the quick support.
Davide
