Semantic Model: kyvos.build.dimensions.materialize

Important

This property is now renamed as Selective dimension materialization under Semantic Model Designer > Aggregation Strategy. You can set the values there, and the behavior remains the same.

Description:

Using this property, the user can control dimension combinations to be pre-aggregated in a semantic model process.

Values and behavior:
Specify the dimension names for materialization using the property dialog. In each dimension combination, dimensions are kept in a specific order (see kyvos.build.dimension.order to know more about dimension order).
While choosing dimension combinations to materialize using this property, only those combinations are materialized, which starts with the chosen dimension(s). For example, consider a
semantic model of 4 ordered dimensions named A, B, C, and D. If you choose dimensions A and C to be materialized, then the following combinations will be materialized:
----------------------------------
Combinations materialized for dimension A
1. A
2. AB
3. ABC
4. ABCD
----------------------------------
Combinations materialized for dimension C
5. CD
----------------------------------
By default, all dimensions are materialized.

Default value:
Blank
There is no default value provided to this property. All dimensions are materialized.

Scope:
The property can only be set on a semantic model.

Comes into effect:
The value of the property can be changed at any time, and a full process is required for changes to come into effect. Value changes before an incremental process would cause failures.

Dependencies and related properties:
kyvos.build.dimension.order

Recommendation:
The purpose of this property is to reduce the cube build time and size by materializing selective dimension combinations during the semantic model process. Doing so may impact query performance.