Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 semantic model.
To identify unrelated dimensions, click the fact transformation on the DRDdimension. 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.

...

Recommendation:
Change the property value only for multi-fact schema cubesemantic model. For single-fact schema cubes semantic models (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 semantic model, only the relevant cross combinations will be calculated, resulting in better query performance.

...