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.