Set Level Allocation

When a measure applies to only some levels in a regular or time dimension, you can allocate the measure from a level where it applies to all lower levels that have no relationship established.

When you allocate a measure from a level, all categories in the level inherit the allocation type. However, you can change the allocation type of individual categories.

Procedure

  1. In the Dimension Map, double-click the parent level of the levels to which you want to allocate measure values, to open its property sheet.
  2. Click the Allocation tab.

    A list of measures that are candidates for allocation appears.

  3. In the Measure list box, right-click the Allocation type for the measure, and select an option.

    The allocation types include Do Not Allocate, Constant, and By Measure.

    Tip: You can check the relationships between dimensions and a measure by using the Show Scope command on the Edit menu.