Best Practices for Member Formulas
- Use the @NONEMPTYTUPLE() directive when the formula assigns Sparse cross-dimensional references. Using this directive will cause query execution to occur in bottom-up mode and to resolve dependency analysis quickly in cases where the formula cache is sparse.
- Try to limit the scope of a formula to only include relevant members.
- Hybrid Only: Avoid returning direct constants. See this section Dynamic Calculations in Hybrid Aggregations
- Hybrid Only: Avoid level 0 Dynamic Calc members without formulas.
- Hybrid Only: Avoid the Two Pass Calculation property. Instead, use Solve Order.
- Hybrid Only: See Functions Not Supported for Hybrid Aggregation in Hybrid application models in Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud.
- Avoid returning #MISSING in formulas.