Document toolboxDocument toolbox

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. 

 

Copyright Kyvos, Inc. All rights reserved.