Best Practices

Here are some best practices for designing business rules, including the use of proper commands, use of syntax, optimization guidelines, recommended calculation levels, aggregation options, and debug methodology.

In this Section

• Environment Setting
• Optimize BSO Cubes
• Resolve Cube Outline Warnings
• Optimization and Performance Considerations
• Avoiding Recursion Error
• Use of FIX Statements
• Use of IF Statements
• Block Calculation
• Calculation Levels
• Syntax Considerations
• Use of Block Mode and Cell Mode
• Recommendations for Creating Blocks and Block Size
• Use of BottomUp and TopDown Calculations
• Aggregations
• Use of SET CALCPARALLEL and FIXPARALLEL Calculation Commands
• Use of XRANGE to Calculate a Date Range