Example 3: Basis Time Span—Multiple Members; Target Time Span—Empty or Single Member

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

 RangeTotal
Members in Basis Time SpanDept_1Dept_2Dept_3Dept_4Dept_5Dept_6 
Dec 07123456 
Jan 08234567 
Feb 08345078 
Mar 08456189 
Apr 085672910 
Total

15[1]

2025123540

147[2]

1 Basis for each range member summed across the basis time span periods

2 Total basis for the range

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

 RangeTotal
 Dept_1Dept_2Dept_3Dept_4Dept_5Dept_6 
Target102.04136.05170.0781.63238.10272.11

1000[1]

1 Total allocated values

The total allocated values across the range is the original amount value (1000).