asked on November 11, 2024
It would be useful for us to be able to do drill up/down/to similar to Excel's Quick Explore function. Is this something you can consider adding to Flexmonster?
The Quick Explore function allows to explore related data in other hierarchies, moving the current selected row hierarchy to the filter and replacing the row with the new hierarchy.
I think the following steps are needed to accomplish this:
1) Call pivot.getAllHierarchies()
2) Modal popup displaying hierarchy results for user to select new hierarchies
3) Calculate new rows and filters based on the users selection and whether it is a drill up/down/to operation.
4) Update the report slice with the new rows and filters
Drill down: move current row dimension to the filter and set the new dimension as the row
Drill up: remove lower level hierarchy and replace it with higher level dimension in rows, adjusting filter unless the current level is already there.
Drill to: replaces current row with new hierarchy level, effectively jumping to a new dimension or level.
Is there anything else you can advise on the subject and Flexmonster's capabilities to do this?
⋅ November 13, 2024
Hello Yosef,
Thank you for reaching out to us and describing the details.
Currently, there is no plan to add the Quick Explore function to Flexmonster out of the box. However, you are correct that it is possible to achieve this on your side using the Flexmonster API. You are welcome to check the description of all our objects, calls, and events.
Kindly note that if you are using the "microsoft analysis services" data source type, it is important to use the async equivalents of the methods (e.g., getAllHierarchiesAsync).
You are welcome to contact us if further questions arise.
Kind regards,
Nadia
