B Database Upgrade

Upgrade from Oracle Database 10g Release 2 (10.2.0.3) to Oracle Database 10g Release 2 (10.2.0.4)

Oracle Retail Data Model works without any problem with the Relational, Oracle OLAP, or Data Mining components.

Upgrade from Oracle Database 10g Release 2 (10.2.0.3 or 10.2.0.4) to Oracle Database 11g Release 1 (11.1.0.6 or 11.1.0.7)

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.

Upgrade from Oracle Database 11g Release 1 (11.1.0.6) to Oracle Database 11g Release 1 (11.1.0.7)

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:

1. 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.)

2. Expand the Cubes node and perform the following actions on the OOS_INV, OOS_INV_FCST, OOS_SALES and OOS_SALES_FCST cubes:

   1. Expand cube-specific node (that is, the node that represents the one of the cubes).

   2. Expand the Cube Scripts node.

   3. 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

      
      

   4. Select and delete the last step of the default Cube Script (that is, the "Analyze" step). Apply your changes.