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
CostCtr1 | CostCtr2 | |
---|---|---|
Project1 | 1 | 1 |
Project2 | 1 | 1 |
Project3 | 1 | 1 |
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
CostCtr1 | CostCtr2 | |
---|---|---|
Project1 | 1 | 1 |
Project2 | 1 | |
Project3 | 1 | 1 |
The range and excluded range can consist of only level 0 members.