The aggregation type (query-based) is applied only when using hybrid queries.
On-screen aggregation is first processed using the aggregation function defined in the i-META for each analysis item, followed by the execution of the hybrid aggregation function in sequence.
[ View Hybrid Query in Log Viewer Server ]
Hybrid Query
Only the minimum data necessary for calculation is extracted, enabling faster processing compared to the traditional method of computing over the entire dataset.
Columns required for actual calculations are selected based on the field arrangement in the OLAP layout.To enable distributed processing of calculation logic, basic group functions that can be handled at the DB level are utilized.
Database aggregation functions are applied according to the aggregation functions defined for OLAP grid fields.When the layout of the OLAP grid is changed, the server automatically re-queries the data.
Depending on the query performance of the source SQL, caching functionality can be leveraged through integration with i-BIG.
