Setting the Range

Range specifies a symmetric region in the database in which allocated values are calculated and written.

If you do not want allocation values written to certain cells within the range, use the excluded range parameter to express a symmetrical subset of the range. Even when excluding a subset of the range, Essbase uses all cells in the range to calculate allocated values.

When you exclude cells from the range, the sum of allocated values might be less than the value of the amount.

The following examples assume that the range consists of six member combinations, the amount is 6, and the allocation method is spread, in which Essbase evenly allocates the amount across the range. The allocation spread amount is 1 (6/6 = 1).

As illustrated in Table 212, Essbase writes 1 in each cell in the range.

Table 212. Example: Allocating the Amount to Each Member in the Range

 CostCtr1CostCtr2
Project111
Project211
Project311

As illustrated in Table 213, if the excluded range is set to the member combination of (Project2,CostCtr2), Essbase does not write the allocation spread amount to that cell. Therefore, the sum of allocated values (5) is less than the amount (6). The value of the excluded cell after the allocation process is either #MISSING or zero.

Table 213. Example: Allocating the Amount to Only Some Members in the Range

 CostCtr1CostCtr2
Project111
Project21 
Project311

The range and excluded range can consist of only level 0 members.