Enable this property to split the Measures table into individual tables and distribute measures into their respective dimension tables.

Data Type

bool

Default Value

false

Remarks

By default, the provider groups all measures into a single table called Measures. When you enable SplitMeasures, the provider reorganizes the measures in the following ways:

• Separate Tables for Measures-Only Groups: If a table contains only measures, the driver creates a dedicated table for those measures.
• Integration with Dimensions: The driver includes measures in their corresponding dimension tables if applicable.

This property is useful for creating a more intuitive schema layout when analyzing datasets with numerous measures and dimensions. Use this property with the SplitMeasuresOn property to control how measures are grouped into subtables based on attributes such as MeasureGroup or DisplayFolder.