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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.