Description:
This property specifies the dimension order of the actual semantic model file. When a semantic model is builtprocessed, dimensions are arranged in decreasing order of cardinality, with the highest cardinality arranged first. This property overrides the cardinality order. Changing the order can affect semantic model size, cuboid count, and query performance.
Default value and behavior:
By default, the dimension order is computed dynamically during a full semantic model buildprocess. The dimensions are arranged in decreasing order of cardinality.
...
Scope:
Semantic Model: If the property is set on a cubesemantic model, then the value will override the connection level value for that semantic model's job.
...
Example:
When working with Olympics data, the Athlete dimension has the highest precedence due to its highest cardinality. However, since other dimensions are queried and filtered more frequently, such as Country or Event, these dimensions can be moved higher to improve query performance. But, this may result in a larger cubesemantic model.