Page tree
Skip to end of metadata
Go to start of metadata

Description:
This property specifies how to handle unrelated dimensions and measures in a multi-fact schema. The property is applicable for all the measure groups defined in the cube.
To identify unrelated dimensions, click the fact dataset on the DRD. When you click a fact table, the DRD will highlight all the related dimension datasets. The non-highlighted datasets are unrelated to the clicked dataset.

Values and behavior:
True: The measure will repeat the total (ALL member value) for unrelated dimensions across all levels and attributes.

For example, if the Unit Price measure is not related to the Sales Channel dimension, and the kyvos.query.unrelateddim.ignore property is set as True, then the Total of Unit Price is repeated for all Sales Channels as shown in the following figure.

False: The measure will show the unrelated dimension as blank across all levels and attributes.

For example, if the Unit Price measure is not related to the Sales Channel dimension, and the kyvos.query.unrelateddim.ignore property is set as False, then the measure shows value for the ALL member only.

Default value:
True

Scope:
Cube

Comes into effect:
The property comes into effect in a new browsing session after setting the property on the cube. This property does not require a cube rebuild.

Dependencies and related properties:
None

Recommendation:
Change the property value only for multi-fact schema cube. For single-fact schema cubes (single file, star schema, or snowflake schema) keep the property value to default, i.e., TRUE.
By setting the value to FALSE in a multi-fact schema cube, only the relevant cross combinations will be calculated, resulting in better query performance.



  • No labels