Identify which cubes include a specific dimension

You can now quickly identify which cubes on a Planning Analyticsdatabase include a specific dimension. This is helpful when you are thinking about deleting a dimension, but want to see the impact of the deletion on the cubes on your database.

About this task

The View related cubes option is available only on a modeling workbench. The option is available on the right-click menu anywhere you can see an individual dimension name on the Databases tree:

DatabaseName > Dimensions > DimensionName
DatabaseName > Cubes > CubeName > Dimensions > DimensionName
DatabaseName > Control Objects > Control Dimensions > DimensionName
DatabaseName > Control Objects > Control Cubes> CubeName > Dimensions > DimensionName

Procedure

Right-click a dimension on the Databases tree on a modeling workbench.
Click View related cubes.

If the dimension is not included in any cubes, you receive notification and can cancel the procedure.
On the Related cubes window, toggle the Include control cubes option to show or hide control cubes in the list of cubes.
In the Cubes list, select the cubes you want to open for review.
If the dimension is included in five or fewer cubes, the cubes are shown in a simple list.

If the dimension is included in more than five cubes, the cubes are shown in a searchable menu list.
Click Open.

Each of the cubes you selected opens for review on a separate tab on the modeling workbench.