Semantic Model: kyvos.build.aggregate.type

Description:

This property specifies the type of aggregate structures used for persisting the aggregated data of a semantic model.

Default value:

Multidimensional

Values and behavior:

Multidimensional: Enables storage of the aggregated data using Kyvos native multidimensional structures. It generally requires a higher amount of disk space/memory for better performance.
Tabular: Enables storage of the aggregated data using modern tabular columnar structures. Tabular models are generally smaller in size and require less time for processing.

Scope:

Semantic Model

Comes into effect:

From the next full job process

Dependencies and related properties:

NA

Advanced hierarchies will not be supported.
Many-to-many and SCD will not be supported.
Update aggregates will not be supported.
Decimal types of measures will be stored/retrieved as double types; thus, we could observe data accuracy due to precision in such scenarios.
User queries with measures like Approximate distinct count or semi-additive measures would be inefficient as their aggregation pushdown is not supported. Thus, we may observe slowness in such cases.
Data store reading from any distributed file system will not be supported. Thus, we would be required to replicate all the cuboids locally to be able to browse the semantic models.
Entity modification will not be supported.