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.