Dynamic SQL
Dynamic aggregation uses dynamic SQL queries to perform dimension
scanning, find constituents, and aggregation processing. These dynamic
queries are based on configuration of:
The Source of Dynamic SQL
Data sources provide
template SQL that is used as the basis for dynamic queries. This template
SQL is extended by additional SQL generated from the data source configuration
as well as configuration defined for measuring component sets, measuring
components, and measuring component types that reference the data
source. The ways in which the template SQL is extended is based on
the type of process:
- Dimension Scanning: The data source template SQL is extended by the criteria, dimensions, and individually managed items configured on the measuring component sets being processed.
- Find Constituents: The data source template SQL is extended by attributes defined on the aggregation measuring components being processed.
- Aggregation: The data source template SQL is extended by the value identifiers defined on the measuring component type of the aggregation measuring components being processed.