asked 5 days ago
Hello Flexmonster Team,
A few years ago, I inquired about this feature when we began using Flexmonster (we are still on version 2.7.14). Since then, I have reviewed all updates and the API documentation, but I have not found a solution, so I am reaching out again.
Is there a built-in method to expand a specific dimension (or hierarchy) when the data source is an OLAP cube (from SSAS)?
I am aware that the expandData API method only supports CSV and JSON data sources. I also know about the expandAllData API call, but we do not want to expand all dimensions or hierarchies in the pivot table. Not even expand just all rows, or just all columns. Instead, we need the ability to expand only specific ones.
For instance, if there are three different dimensions in the rows, we would like to expand just the first one while keeping the other two collapsed. We would prefer not to implement this functionality manually, as our reports allow customers to sort multiple dimensions (with and without hierarchies), expand, drill down, etc., in both rows and columns.
Developing this functionality ourselves would be overly complex and prone to errors.
Has this feature been implemented in Flexmonster yet?
Thank you very much for your assistance.
⋅ 2 days ago
Hello Javier,
Thank you for reaching out to us.
Currently, Flexmonster only supports expanding a specific hierarchy for JSON and CSV data sources. If you are using an OLAP cube as a data source, it is only possible to expand each member separately from the UI or expand all data programmatically via expandAllData API call. At the moment, there are no plans for adding this feature for the SASS data sources, but we have added it to our customer's wishlist. Our team will notify you if there are any updates on the matter.
You are welcome to contact us if other questions arise.
Kind regards,
Nadia
⋅ 1 day ago
Hello Nadia,
Thank you very much for your response. We sincerely hope that this functionality will be introduced in the future.
I have just one more question. Am I correct in assuming that the expandCell API call (https://www.flexmonster.com/api/expandcell/) does not work in our case? I attempted to use it, but it does not seem to have any effect.
However, the documentation for expandCell does not mention any source limitations, whereas the documentation for the expandData API call explicitly states such limitations.
Thank you once again for your assistance.
⋅ 1 day ago
Hello Javier,
Thank you for the response.
Flexmonster supports the expandCell API call for the OLAP data sources. We have prepared an example for reference: https://jsfiddle.net/flexmonster/oe4mv62a/. Also, to get the correct tuple name, you can expand the specific member, save the report via the Toolbar, and check the name in the expands.columns.tuple array of the Slice object.
Please note that this API call was added in Flexmonster version 2.9.6. That is why we recommend updating to the latest version. You are welcome to check our guide for more details: https://www.flexmonster.com/doc/updating-to-the-latest-version/. If you are using the 2.7.14 version, please refer to the following migration guides:
Please let us know if it works for you. Looking forward to hearing your feedback.
Kind regards,
Nadia
