Semantic Model: kyvos.build.aggregate.storage.optimized

Description:
This property controls storage choice for persisting the aggregates and helps improve query performance for the cases when a semantic model is not fully aggregated.

A true value for this property allows for storage that is more IO optimized for large data scans during query execution. A false value allows the storage choice that better exploits redundancy across aggregates.

When a semantic model contains a large number of dimensions, full pre-aggregation may lead to a large semantic model size. Kyvos provides ways to reduce the degree of aggregation, and setting this property value as true would provide better IO performance for querying.

Default Value:

For semantic models  designed with Kyvos 2021.3 or later: true
For semantic model designed with a Kyvos version earlier to Kyvos 2021.3: false

Related Properties:

Precompute level threshold (under Aggregation Strategy).