Posted 3 August 2017, 3:54 pm ESTHello
I would like to know if DDA has support for loading data on demand. For example, suppose a layout that as a Row field has Product hierarchy and as Data field it has Sales. So, when loading the pivot grid one would see the aggregates for the first hierarchy level, and if one clicks to drilldown one would see the agregates for the next level. I meant by loading data on demand that when clicking in order to drilldown, that it would allow the application to run a new query in order to retrieve the data for the next aggregate level, given the ID of the clicked pivot item. That is, at first only the aggregates of the first hierarchy level would be loaded. Then the aggregates of the next levels on demand. This would allow to balance the loading of data and give a better user experience when dealing with large volumes of data.
Is that possible?
Thanks a lot.