Amount specifies the source of the allocation. The amount value is allocated to cells in the target region. The amount, which can consist of upper-level or level 0 members, can be expressed as a numeric value expression, a tuple, or a constant.
How you express the amount determines certain requirements:
Numeric value expression:
All members in the expression must be from the same dimension.
Tuples cannot be used in the expression.
Only arithmetic expressions (+, -, /, and *) can be used in the expression.
MDX functions (such as Avg and Parent) are not allowed.
For example:
(Acc_1000 + Acc_2000)/2 AccA + AcctB Balance * 1.1
Tuple:
The tuple must use one member from every dimension that is not specified in the POV.
The amount context must be empty.
For example:
(Balance,Cost_Center_00,Project_00) (Balance,Cost_Center_00,Actual)
Constant:
The amount context must be empty.
The amount time span must be empty.
For example:
100
You can use these parameters to further define the amount:
(Optional) Amount context provides additional context, or specificity, for the amount. The amount context, which can consist of upper-level or level 0 members, can be expressed as a tuple. By specifying the amount context, you can include a member from a dimension that is not specified in the POV.
When using amount context, these requirements apply to the amount and the amount context:
The parameters cannot refer to members in the same dimensions.
Together, the parameters must use members from every dimension not specified in the POV.
(Optional) Amount time span specifies one or more time periods to be considered for the amount. The amount value is aggregated over the specified time periods, and the aggregated amount value is allocated. Time periods must be level 0 members in a Time dimension.
When amount is specified using an arithmetic expression, and amount time span is used, amount time span takes precedence over any formulas in the amount or any formula members used in the amount. For example, assume that the amount is specified as Dept_A/Dept_B and amount time span is set to Jan, Feb, Mar, and Apr for each department, as shown in Table 214. The amount to be allocated for the POV is calculated by dividing the amount time span value for Dept_A (10) by the amount time span value for Dept_B (20), which is 0.5.
(Optional) Zero amount options specifies how to treat the amount if the value is zero or #MISSING. You can choose to allocate zero values (the default), skip to the next nonzero or non-#MISSING amount value, or cancel the entire allocation operation.
You can use amount context and amount time span to achieve the same result, as shown in following example. The amount is the value of Dept_A, but amount time span is used to focus only on the months of Jan, Feb, Mar, and Apr for Dept_A. As shown in Table 215, the aggregated value of the members included in the amount time span (10) is the amount value that is allocated across the cells in the range.
You can achieve the same amount value by specifying amount as an arithmetic expression of Jan + Feb + Mar + Apr and setting the amount context as Dept_A, as shown in Table 216: