Updating Application Dimensions

If any changes to dimensions or dimension members are required in an application with Deploy Origin of Master Cube – such as adding, deleting, changing, or renaming – you must update the dimensions in the Oracle Essbase Master Cube and then update the Oracle Hyperion Profitability and Cost Management application.

Caution:

If you need to rename or delete dimensions in an Essbase Master Cube, consider creating a separate Essbase Master Cube so that your existing Profitability and Cost Management applications can still be updated if necessary. Also, you cannot update dimensions using the Profitability Applications Console if the name of the Essbase Master Cube database is not the same as the name of the Profitability and Cost Management application that is based on it.

Whenever the Profitability Applications Console is used to update dimensions, a Job entry is automatically created in the Job Library to validate and update the application.

To update Essbase dimensions in a Profitability application created in the Profitability Applications Console:

1. From Oracle Hyperion Enterprise Performance Management Workspace, select Navigate, then Administer, and then Profitability Applications.
2. In the Applications tab, select the application that contains the dimensions and dimension members to update.
3. Select Actions, and then Update Dimensions.

   Typically, you would perform a Pre-Update Analysis and then select Update Dimensions.

4. Optional: Under Pre Update Analysis, select Validate Dimensions to verify that each of the selected changes are valid. This option does not update the dimensions. If all dimensions have been selected, this option also runs the application level dimensions validations.

   Validation errors and the results of the impact analysis are displayed in the Job Library.

5. Optional: Under Pre Update Analysis, select Impact Analysis to perform a comparison between the model being deployed and the existing model in Profitability and Cost Management. If Impact Analysis is selected, the Validate Dimensions option is selected automatically.

   The following information is displayed:

   • New Members

   • Deleted Members

   • Re-Parented Members

   • Members with Level0 change

   • Impacts on referencing model artifacts

   Validation errors and the results of the impact analysis are displayed in the Job Library.

6. Optional: Check Update Dimensions to update the selected dimensions with the changes.
7. Under Dimensions, do one of the following:

   • If you are updating an application with Deploy Origin of Master Cube, select the dimensions to update.

     Note:

     Dimension members that are not selected will be omitted or deleted if they were previously included.

   • If you are using flat files to add or update dimensions to a Management Ledger application with Deploy Origin of File, browse to select a flat file for the dimension to update.

8. Click OK. Any exceptions are reported in the Job Library.

   If you selected Pre Update Analysis, the modified dimensions are validated but not updated.

   If you selected Update Dimensions, the selected dimension members are added, updated, or deleted according to dimension selections, or the selected flat file is imported.

Note:

If you are updating with flat files, repeat necessary steps until all flat files have been imported. Be sure to use the Validate and Enable option to ensure that files were imported correctly.