I am trying to change the allocations for a measure, but the Allocation tab on all the Level Property sheets is disabled (grayed out). Why?
There are 2 things you should no about allocation
1. Transformer automatically allocates a measure as a constant throughout an entire dimension when
the source of the measure does not reference that dimension.
2. 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
How to go about setting this up
For Type 1 - Set Dimension Allocation
------------------------------------------------------------------------------------------
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.
For Allocation Type 2 - Set Level Allocation
---------------------------------------------------------------------------------------------
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.