Validating the Essbase Outline
Pre-validate the Essbase outline to ensure that your application is compatible with a Hybrid Essbase version.
As part of an effort to upgrade all environments to an Oracle Essbase version that supports Hybrid Block Storage Option (BSO) cubes, Oracle has added a process to pre-validate Essbase outlines to ensure a smooth transition when your environment is upgraded to a Hybrid Essbase version.
Note:
For information about Essbase versions, see About Essbase in EPM Cloud in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators.
To ensure that your application is compatible with a Hybrid Essbase version, we've implemented a new utility which verifies the member formulas in your environment and provides a report so you can fix any issues.
The utility can be launched manually and it will run automatically during database refresh:
-
For information about manually launching the utility, see Manually Launching the Pre-Validation Process.
-
For information about automatic launch during database refresh, see Automatic Pre-Validation During Database Refresh.
If errors are found after the utility completes verification of the member formulas, you can view the Outline Pre-validation Report and fix the errors it finds. If no errors are found, no additional action is required.
Note:
Additional validation errors might occur after you migrate to a newer version of Essbase.
Manually Launching the Pre-Validation Process
To manually launch the pre-validation process, select from the following options under the Essbase Outline Validation menu option in the Actions menu on the application's Overview page:
-
Pre validate Outline: Performs a validation of your application
-
Outline Pre-validation Report: Displays a list of member formulas that need to be fixed to be compatible with Hybrid Essbase version
Note:
-
The Essbase Outline Validation menu option only displays if your environment is on a non-Hybrid Essbase version. If your environment is on a Hybrid Essbase version, then the Essbase Outline Validation menu option is no longer available.
-
Another way to check whether your environment is on a Hybrid or non-Hybrid Essbase version is to view the value of Essbase Version supports Hybrid Block Storage Option in the Activity Report. If the value is Yes, it means that your environment is on a Hybrid Essbase version. If the value is No, then your environment is on a non-Hybrid Essbase version.
To validate the Essbase outline in your environment and to fix any errors found in member formulas:
-
From the Home page, click Application, and then click Overview.
-
Click Actions, select Essbase Outline Validation, then select from the following options:
-
To perform the validation, select Pre validate Outline.
-
To view and download a report of errors found during validation, select Outline Pre-validation Report.
-
After you have fixed the member formulas, you can use the Pre validate Outline option again to make sure that all issues are resolved.
Note:
After fixing the member formulas, ensure that you refresh the database before viewing the pre-validation report again, otherwise the report won't show that all the errors are resolved.
Automatic Pre-Validation During Database Refresh
If the system detects that your environment uses a non-Hybrid Oracle Essbase version and will need to be upgraded to Hybrid Essbase, the validation utility will automatically launch at the end of the Refresh Database process.
To refresh the database, see Refreshing Application Databases.
If member formula errors are discovered during the validation process, you'll see a warning telling you to review the report and address any errors. Click View Outline Pre-validation Report to view the full report and resolve any errors.
For a list of sample pre-validation errors, see Validating the Essbase Outline in Getting Started with Oracle Enterprise Performance Management Cloud for Administrators .