Using the Allocate - Level to Level Template
Use the Allocate Level to Level template to allocate from one level to another in the database outline.
For example, you could use the Allocate - Level to Level template to allocate products from one level to another. Assume you have a the following product outline:
T_TP
P_000
T_TP1
P_100
P_110
etc
T_TP2
P_200
P_210
etc
T_TP3
P_291
P_292
In this example, you would use level/generation 3 for the start and level/generation 4 for the end in the Allocate - Level to Level template to allocate from the parent members (T_TP1
, T_TP2
, T_TP3
) to their children (level 0) members.
To use the Allocate - Level to Level template:
Table 4-4 Allocate - Level to Level Wizard Steps
Steps | Explanation |
---|---|
Point of View | Select one or more members for each dimension listed that you do not want to vary during the allocation.
The following options are available:
|
Source | For each dimension listed, select the member whose data you want to allocate. After you select the members, enter the percentage of the source to allocate.
Note: Leave the dimension to use for the level to level allocating empty. (You select this dimension in the next step.) |
Allocation Range | Define the allocation range by entering the requested information.
The rule allocates all data below the selected member, from the level specified as start level, down to the level specified as end level. |
Target |
|
Offset |
Define the offset or leave the table in this step blank if you don’t want to generate an offset calculation. If you do define an offset, do the following:
|
Driver | Define the driver (basis) used to calculate the percentage applied to each member of the allocation range.
|
Other Options | Answer the questions in the wizard. |