Yes, DataPA in V4 now supports summary queries.


These enable you to use your subjects to create summarised ""cubes"" of data which are processed on the AppServer and only the summarised results being passed back to the client application.


The summary queries also have the ability to identify trends as well as just returning Top N or Bottom N data.


Summary queries can be created in all DataPA applications namely DataPA Reports, DataPA Enterprise Dashboard and the DataPA Excel Add-in.


This video shows an example of a summary query being used in the Enterprise Dashboard as the data source for more than one dashboard object.

 


Watch the Video.