When running a report containing chart in Intellicus, the data aggregations like group by, sorting, filtering etc. is performed at the database source in case of any RDBMS or analytical database source. Intellicus receives the aggregated data from the respective database source to be written to a view or report to further analyze the report data to gain insights.
This enables Intellicus to utilize the data processing capabilities of various RDBMS data sources and provide improved performance in rendering reports.
For non-RDBMS data sources, the aggregations are performed by Intellicus using its staging database, after fetching all the queried data.
For ad hoc reports, aggregation does not happen if the report has a grid control.