Unsupported Functions and Formulas for Calc on the Fly
Certain functions and member formulas are not supported for performing calc on the fly.
They are as follows:
- Members having assignments to themselves or other members are not allowed in
member formulas. For example,
sales = 100 + units *rates;
- Only single value formulas are allowed.
- Multi-statement formulas are not allowed. For
example,
Allowed:
if(sales > 100) 10; units * 1.01; else units + 10; endif;
Not Allowed:
If (units > 10) 10; endif; units + 10;
- Functions that require more than 50,000 off sheet cells are not supported.
- Recursive formulas and circular references, where a formula refers to its own cell directly or indirectly, are not allowed.
- The following list of Essbase calculation functions are not supported for calc
on the fly:
- @TODATE
- @ISRANGENONEMPTY
- @MDANCESTVAL
- @MDPARENTVAL
- @RETURN
- @SANCESTVAL
- @SHARE"
- @SPARENTVAL
- @XREF
- @XWRITE
- For ASO cubes, only outline math is interpreted while inserting member formulas. MDX formulas are not supported.