The allocation feature distributes data, specified at a summary level of a dimension, to lower levels. For example, actual sales revenue may be tracked daily, while sales revenue is forecast quarterly. Allocation is a useful way of distributing quarterly forecasts to the month and day levels.
The following types of allocation are available:
From Level (typically by direct association with the data source)
N/A (do not allocate)
Constant (allocate a measure as a constant value to all descendants)
By Measure (allocate to descendants proportionally according to another measure)
You can allocate measures
over entire dimensions, when the measure appears in a data source that does not reference the dimension
over levels in a dimension, when the measure is already specified at a level in that dimension
over categories in levels, when the measure is specified to the particular level
Process
Add two or more data sources to a model.
Define the measures.
Create a dimension map.
Allocate measures to dimensions or levels that lack them.
Check the relationships between dimensions and a measure by using the Show Scope command.
CP
![[cook] [cook] [cook]](/data/assets/smilies/cook.gif)