ALLOC-NUMERIC
The ALLOC-NUMERIC terminal in the MaxL language for Essbase is an MDX numeric value expression used to specify the amount value for an allocation source.
The amount value is allocated to cells in the target region of an Essbase aggregate storage cube. The allocation numeric is one of the following:
-
An MDX tuple
-
A number
-
An arithmetic expression using member names, with the following restrictions:
-
All members in the expression must be from the same dimension.
-
Tuples cannot be used.
-
Only arithmetic operators (+, -, /, and *) can be used.
-
MDX functions (such as Avg and Parent) are not allowed.
-
Type
string (see MaxL Syntax Notes)
Examples
-
(Acc_1000, Jan_2009) -
100.00 -
(Acc_1000 + Acc_2000)/2 -
AcctA + AcctB -
Balance * 1.1
Referenced By