Validating Custom Calculation Rules

When you access the Validation tab, any errors or warnings in your custom calculation rules are displayed. The validation checks each rule for these conditions:

  • The rule is fully defined

    This means that the target definitions for each rule must include members for every dimension.

  • Dimension members referenced in your rule definitions exist in the database

    If you delete members from dimensions that are referenced in existing rules, the rules cannot run.

If you have several validation errors or warnings, click Export to Excel. You can use the Excel spreadsheet as a checklist as you go back to the Target tab to fix the errors and warnings.

Continue fixing any errors in your rules until there are no errors listed on the Validation tab.

Note:

See Validation Errors and Warnings for details on the errors and warnings that may occur when validating your custom calculation rules.