Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Allocations in Transformer Model

Status
Not open for further replies.

bobg4u

IS-IT--Management
Jun 3, 2003
46
CA
What is the signaficance of allocations in the Transformer Model.How do we use them? Can someone help me with an example?

Thanks
Bob
 
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top