In the need of some drill down functionality and detail views I was thinking about to execute the OQL dataset in Java and store the results in Mendix objects with associations to source data. I can show the aggregated data in a datagrid and create microflows to drill down. That is not easy with aggregated data. Better solutions? Edit: The zoom function is an option. Thanks Stephan.
Chris de Gelder
You can use indeed an entity related to your source data via a reference set. Then write a java program executing the OQL string that uses ID in the SELECT part and populate the reference set.
Mind you, you need 2 versions of the OQL string. One with GROUP BY for aggregates and one without for retrieving the individual records.