Unsupported Functions and Formulas for Calc on the Fly
Certain functions and member formulas are not supported for performing calc on the fly.
The following are not supported for calc on the fly:
- Members having assignments to themselves or other members are not allowed in
member formulas. 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:
sales = 100 + units *rates;
If (units > 10) 10; endif; units + 10;
- 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
- MDX formulas are not supported.
- Member formulas that use a Smart List expression are not supported.