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.