Example 4: Basis and Target Time Span—Multiple Members; Basis Time Span Option—Split

In this example, multiple time periods are specified for the basis time span and the target time span, and the basis time span option is set to split. When using the split basis time span option, the periods specified by the basis time span and target time span must be identical. (For an example of setting the basis time span option to combine, see Example 5: Basis and Target Time Span—Multiple Members; Basis Time Span Option—Combine.)

Assume the amount is 1000. As shown in Table 227, the total basis for the range is the sum of all department basis values (165):

Table 227. Example 4: Basis Values

 RangeTotal
Members in Basis Time SpanDept_1Dept_2Dept_3Dept_4Dept_5Dept_6 
Dec 07123456

21[1]

Jan 0823456727
Feb 0834567833
Mar 0845618939
Apr 08567291045
       

165[2]

1 Total basis for each basis time span period

2 Total basis for the range

The allocation is calculated using the basis time span setting of split, which uses the basis value for each time period individually.

The algorithm Essbase uses:

alloc_amt = (basis_mbr_value/basis_total_range) * amount

As shown in Table 228, for Dec 07,Dept_1, the member basis value (1) is divided by the total basis for the range (165), and the result (0.00606) is multiplied by amount (1000): (1/165) * 1000 = 6.06. Essbase continues to perform allocations for each time period for each department.

Table 228. Example 4: Allocation Using Basis Time Span Set to Split

 RangeTotal
Members in Target Time SpanDept_1Dept_2Dept_3Dept_4Dept_5Dept_6 
Dec 076.0612.1218.1824.2430.3036.36127.27
Jan 0812.1218.1824.2430.3036.3642.42163.64
Feb 0818.1824.2430.3036.3642.4248.48200.00
Mar 0824.2430.3036.3642.4248.4854.55236.36
Apr 0830.3036.3642.4248.4854.5560.61272.73
       

1000[1]

1 Total allocated values

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