In this example, multiple time periods are specified for the basis time span, but the target time span is not set. The target time span option is ignored. The only valid choice for the basis time span option is combine.
Assume the amount is 1000. As shown in Table 225, the basis to be used for each department is the sum of the basis values for the basis time span (Dept_1 = 15); the total basis for the range is the sum of all department basis values (147):
Table 225. Example 3: Basis Values
Range | Total | ||||||
---|---|---|---|---|---|---|---|
Members in Basis Time Span | Dept_1 | Dept_2 | Dept_3 | Dept_4 | Dept_5 | Dept_6 | |
Dec 07 | 1 | 2 | 3 | 4 | 5 | 6 | |
Jan 08 | 2 | 3 | 4 | 5 | 6 | 7 | |
Feb 08 | 3 | 4 | 5 | 0 | 7 | 8 | |
Mar 08 | 4 | 5 | 6 | 1 | 8 | 9 | |
Apr 08 | 5 | 6 | 7 | 2 | 9 | 10 | |
Total | 15[1] | 20 | 25 | 12 | 35 | 40 | 147[2] |
The allocation is calculated using the basis time span setting of combine, which uses the sum of the basis values across the basis time span periods.
The algorithm Essbase uses for each range member:
alloc_amt = (sum_across_basis_time_span/basis_total_range) * amount
As shown in Table 226, the allocated value for each department is written to one target location, because the target time span is not set to multiple periods. For the allocated amount for Dept_1, the sum of the basis time span (15) is divided by the total basis for the range (147), and the result (0.10204) is multiplied by amount (1000): (15/147) * 1000 = 102.04. Essbase continues to perform allocations for each department in the range.
Table 226. Example 3: Allocation Using Basis Time Span Set to Combine
Range | Total | ||||||
---|---|---|---|---|---|---|---|
Dept_1 | Dept_2 | Dept_3 | Dept_4 | Dept_5 | Dept_6 | ||
Target | 102.04 | 136.05 | 170.07 | 81.63 | 238.10 | 272.11 | 1000[1] |
The total allocated values across the range is the original amount value (1000).