If you install Oracle Retail Data Model and then upgrade the underlying Oracle Database, the Oracle Retail Data Model components may require modifications. This appendix describes steps required when you perform the following upgrades:
Upgrade from Oracle Database 10g Release 2 (10.2.0.3) to Oracle Database 10g Release 2 (10.2.0.4)
Upgrade from Oracle Database 11g Release 1 (11.1.0.6) to Oracle Database 11g Release 1 (11.1.0.7)
Oracle Retail Data Model works without any problem with the Relational, Oracle OLAP, or Data Mining components.
Since the underlying metadata and technology of the OLAP component and the Data Mining component changed in Oracle Database 11g Release 1, it is recommended that you deinstall Oracle Retail Data Model on Oracle Database 10g and re-install Oracle Retail Data Model.
OLAP component: You must re-install the OLAP component as described in OLAP Installation and Configuration.
Data Mining component: You must re-install the Data Mining component as described in Database Objects Installation.
The Relational and Data Mining components work after the upgrade. The OLAP component also works after the upgrade. However, you modify the PSLSINV analytic workspace as follows:
In the Analytic Workspace Manager 11g, open the PSLSINV analytic workspace in Read-Write mode. (For information on installing AWM, see OLAP Installation and Configuration.)
Expand the Cubes node and perform the following actions on the OOS_INV, OOS_INV_FCST, OOS_SALES and OOS_SALES_FCST cubes:
Expand cube-specific node (that is, the node that represents the one of the cubes).
Expand the Cube Scripts node.
Select the name of the default script for the cube as outlined in the following table:
Cube name | Default Cube Script Name |
---|---|
OOS_INV | LOAD_AND_AGGREGATE |
OOS_INV_FCST | AGGREGATE_AND_ANALYZE |
OOS_SALES | LOAD_AND_AGGREGATE |
OOS_SALES_FCST | AGGREGATE_AND_ANALYZE |
Select and delete the last step of the default Cube Script (that is, the "Analyze" step). Apply your changes.