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.