Performing Model Validation Analysis for Management Ledger Models

After a Management Ledger Profitability model is deployed, it can become invalid if dimensions that are used in model artifacts are deleted or renamed.

The following artifacts can be affected by dimension model changes: Program, Rule Sets, Rules, Model Views, and Smart View Queries.

The following processes and task areas reference these artifacts and will display errors if an invalid condition is created: LCM Export, Model Validation, Calculate, Manage Rules, Manage Queries, and Model View.

If a validation error is displayed, yu can learn more about it in the Model Validation task area.

To check for and analyze validation errors:

  1. In an open Management Ledger model, select Validate and then Model Validation.
  2. In the Model Validation area, enter POV information (such as Year, Period, and Scenario), and click Run.

    Errors, if present, display in a Model Validation table. The default tab is for rule sets and rules (Figure 11-5).

    Figure 11-5 Model Validation Results for the Rule Sets and Rules Area


    This screen has a POV, report parameters, Actions and View menus, buttons that reflect the menus, and columns listing error type, rule or rule set name, rule number, status, and an error description.

    The error table for rule sets and rules contains the following information:

    • Error type (location) — Global Context, Rule Set Context, Rule Source, Rule Destination, Rule Driver, or Rule Offset.

    • Name and number of the rule or rule set involved.

    • Status of the rule or rule set, usually Disabled.

    • A description of the error.

  3. Review the Model Views and Queries tabs. Display the tab and click Run.

    Note that hese tabs apply to all POVs, so you do not need to select a POV.

  4. Note errors on any tab. You can click Export to Excel button], or select Actions, and then Export to Excel to export data in the table to a Microsoft Excel file.
  5. Repair the errors and validate again.

Note:

You can fix rule set and rule errors in the Manage Rules task area (Working with Rule Sets for Management Ledger POVs). If a rule has an invalid member, you can remove it by selecting the rule and clicking Save button.

If your security role enables you to log into Oracle Hyperion Enterprise Performance Management Workspace as Administrator, you can also validate deployed applications and perform impact analysis of dimension changes. For details, see Oracle Hyperion Profitability and Cost Management Administrator's Guide.