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 build process

Dependencies and related properties:

NA

Points to know for the Tabular value

• 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 cubes.  

• Entity modification will not be supported.