Creating Measures and Flattening Dimensions

Use the following steps to create measures by flattening the Balance Amount Dimension.

  To create measures and flattening dimensions:

  1. Double-click the db (Cube Table Object) and go to the Hierarchies tab.

  2. Double-click the Balance Amount dimension and change the Dimension Type from other to Measure Dimension and select OK twice to close all open dialog boxes. The following figure is an example.

    This screen shot provides an example of creating dimensions and flattening dimensions from the Physical Hierarchy Balance Amount dialog.

  3. Right-click Database and select Convert measure Dimension to Flat Measures. All measures based on the Balance Amount Dimension are displayed in the physical layer.