Manage cube measures

Use the cube options to manage cube measures, synchronize them with the semantic model, modify breakdown dimensions, and control how cube measures are reused across planning sheets. The Data pane provides separate menus for the entire cube and for individual cube measures, enabling administrators and planners to perform bulk operations or manage specific measures independently.

Modify dimension breakdowns

You configure dimension breakdowns while creating a data input or forecast measure. To edit breakdowns, in the Model ribbon, go to Cube > Manage Breakdown and select the cube measure. Add, remove, or modify the breakdown dimensions associated with the selected cube measure.

Manage cube measures

Use the cube options to synchronize, monitor, and manage all cube measures in a planning sheet. In the Data pane, hover over the Cube section and select the More options (…) menu.

Option	Description
Sync with Data	Synchronize all cube measures with the latest changes in the semantic model.
View Sync Logs	View the history and status of synchronization and cube management operations.
Delete	Permanently delete all cube measures in the planning sheet. This action also removes linked cube measures from other planning sheets and the Data pane.
Collapse All	Collapse all expanded cube measures.
Expand All	Expand and display all cube measures.

Manage individual cube measures

Use the cube measure options to reuse, synchronize, modify, or delete a specific cube measure. In the Data pane, hover over the cube measure and select the More options (…) menu.

Option	Description
Insert as a Measure	Insert the selected cube measure into the current planning sheet.
Sync Measure	Synchronize only the selected cube measure with the latest changes in the semantic model.
Manage Breakdown	Add, remove, or modify the breakdown dimensions associated with the selected cube measure.
Delete	Delete the selected cube measure, remove it from linked planning sheets, and remove its references from the Data pane.