Set Dimension Allocation

Cognos® Transformer automatically allocates a measure as a constant throughout an entire dimension when the source of the measure does not reference that dimension.

However, you can change this default allocation to Do Not Allocate or By Measure (proportionally allocate, based on values in another measure).

Procedure

  1. Open the property sheet for a dimension that is not referenced by the measure you want to allocate and click the Allocation tab.
  2. Right-click the Allocation type for the measure and select an option.
    Tip: You may also allocate measures to an entire dimension from the Categories diagram by double-clicking the Root category.