We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

Drilldown on highchart with OLAP cube data

Answered
arnaud desbiens asked on September 11, 2017

 I was wondering if it is possible to drilldown on highcharts when the data source is an OLAP cube ? I've seen example of how to do it with csv or json file ?

1 answer

Public
Tanya Gryshko Tanya Gryshko Flexmonster September 13, 2017

Hello Arnaud,
Thank you for writing. This example shows how to perform drilldown on Highcharts. Please pay attention to the properties withDrilldown and slice inside flexmonster.highcharts.getData() method. withDrilldown: true means that chart will have drilldowns. If withDrilldown property is too simple for your case, you always can use prepareDataFunction to preprocess the data in your own way. In the above example slice defines the slice for which the data should be returned. However, slice property is not available for OLAP cube data. So flexmonster.highcharts.getData() gets only the data which is currently displayed on the grid. This means you should show in pivot component the data from which the chart will be composed. I hope such approach covers your use case. Please let me know if you have questions.
Regards,
Tanya

Please login or Register to Submit Answer