Support for loading data on demand

Posted by: emoscosocam-dd on 3 August 2017, 3:54 pm EST

  • Posted 3 August 2017, 3:54 pm EST


    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.
  • Replied 3 August 2017, 3:54 pm EST

    Hi EmoscosoCam,

    When connecting to SQL Server Analysis Services cubes we do something very similar to what you are suggesting and generate intelligent MDX queries that return only the data that will be displayed in the pivot grid.

    Doing the same with the relational providers is very difficult to do in a generic way as each provider has a slightly different expectation in its SQL (if it uses SQL at all, f.e. the Object data provider doesn't) and completely different ways in which you would discover the structure of the data source.  Rather than offer some features with some of the providers and not others, we decided to keep it simple and treat all relational data sources the same.

  • Replied 3 August 2017, 3:54 pm EST

    Thanks for your reply.

    Perhaps you might consider creating an event that would be raised before a node is expanded, having as an argument a data structure that would hold not only the level ID that is required, but also the needed columns -so that I would be the responsability of the application to fill the local data source with the necessary data before the DDA control attempts to get it.

    Just a thought.

    Thanks a lot.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels