Adding dimensions to an existing cube

Add a dimension to a cube so that data relationships in the cube can be examined in greater detail. You do not need to create all of a cube's dimensions at the same time. You can add a dimension later, for example, if no data had existed for the dimension when the cube was created.

Procedure

  1. Decide which dimension you want to add to the cube.
    Note: View the Properties pane to see a list of dimensions that are already part of the cube.
  2. In the Model Design pane, expand the Dimensions folder.
  3. Click and drag a dimension to the Rows, Columns, or Context area of the cube viewer.
  4. If there is data in the cells that is not calculated by rules, specify how you want the existing data distributed between the members of the new dimension.
  5. Click the Actions menu icon Actions menu icon, and click Save or Save As.
    The cube is saved and the new dimension is displayed in the Properties pane and in the cube viewer.
    Note: The initial order of the dimensions is determined by the dimension type.