Troubleshooting Business Rules and Member Formula Errors and Performance

How often have you asked the question "How can I optimize slow business rules identified in the Activity Report?"

This section lists the best practices for designing business rules and member formulas to avoid common execution errors. It also describes the steps involved in optimizing slow business rules and member formulas .

Applies to

Oracle Hyperion Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Sales Planning, and Strategic Workforce Planning.

In this Section

• Best Practices
• Writing Optimized Business Rules: Optimizing Essbase Calculation Scripts by Using NOT in IF Statements
• Creating a Business Rule Using a Unit Test
• Debug Methodology for Developing Business Rules
• Business Rule Optimization
• Business Rule Optimization for Hybrid-Enabled Cubes
• Effect of Dynamic Calc Parent Members that have Member Formula with Aggregating Children
• Impact of Enabling Hybrid Cubes on Calculations and Member Formula in Planning
• Troubleshooting Incorrect or No Data in Member Formula in Hybrid BSO and ASO Cubes
• Performing Calculations Using Dates Stored in Planning
• Using a Business Rule to Populate System Date in Planning
• Avoiding the Attempt to Cross a Null Member in Function Error
• Resolving Essbase Error(0): Error Executing Formula
• About Deploying Business Rules to Applications
• Getting Help