Presenter Adaptive - large data volumes
Presenter Adaptive objects can only have one data source.
For optimal performance, it's recommended to move complex joins and excessive sources into calculations.
this allows the system to efficiently process the data once during the batch, versus doing so every time the report loads.
Note
It's NOT recommended to join in the hierarchy on the calculations, this can drastically increase the number of records the queries have to scan and leads to longer sync back times.
The hierarchy should be enforced once on a stored value versus joining into every Data Store.
This will ensure minimal reprocessing of records while the report is loading.