If you do not have the second SAS 9.2 maintenance release installed, then you must use the following process to promote SAS OLAP Cubes from SAS 9.1.3 to SAS 9.2.

Note: If you have the second SAS 9.2 maintenance release installed, you can use the ExportCubes batch tool. For details, see SAS Note 36716.

1. Export the cube-related metadata from the SAS 9.1.3 metadata server by creating two separate packages, as follows:

   1. First, export the relational objects (including libraries, tables, information maps, reports, and stored processes) that are associated with your cubes. Use BI Manager in SAS Management Console 9.1.3 to export these objects to a package called RelationalObjects.spk.

      When you select the tables, you can choose to include or exclude the associated physical data for the input tables. If you exclude the physical data, you will need to move it in a separate step. You might want to exclude the physical data from the package in the following situations:

      • The target metadata server has a different operating system environment than the source metadata server.

      • The tables contain non-English data.

   2. Next, export your OLAP objects (including information maps, reports, and data explorations). Use BI Manager in SAS Management Console 9.1.3 to export these objects to a package called OLAPObjects.spk

2. If you did not include physical table data in the first package that you created (RelationalObjects.spk), use the CPORT and CIMPORT procedures to move the data to the SAS 9.2 environment. For instructions, see the Base SAS Procedures Guide.

3. In SAS OLAP Cube Studio 9.1, use the Save PROC OLAP Code function to export your PROC OLAP code. For instructions, see the SAS OLAP Cube Studio Help.

4. Update the exported PROC OLAP code to incorporate changes that are needed for the SAS 9.2 environment. You might need to change metadata server connection information, OLAP schema names, physical paths to cube file storage, and temporary work locations.

5. Perform the following steps on the SAS 9.2 system:

   1. Import the package that contains your SAS 9.1.3 relational objects (RelationalObjects.spk). This is the package that you created in step 1.a. To perform the import, you can use the Import SAS Package wizard in SAS Management Console 9.2, SAS Data Integration Studio 4.2, or SAS OLAP Cube Studio 4.2.

   2. Execute the PROC OLAP code that you updated in step 4. The code accesses the metadata that you imported in step 5.a and builds your SAS 9.2 cubes.

   3. Apply the appropriate permissions to your OLAP-based objects (including information maps, reports, and cubes). This step ensures that your reports and data explorations can access the OLAP cube data.

   4. Import the package that contains your SAS 9.1.3 OLAP objects (OLAPObjects.spk). This is the package that you created in step 1.b. To perform the import, you can use the Import SAS Package wizard in SAS Management Console 9.2, SAS Data Integration Studio 4.2, or SAS OLAP Cube Studio 4.2.

   5. Validate your OLAP cube content by running OLAP reports and data explorations.

For information about how OLAP cube objects are stored differently between SAS 9.1.3 and SAS 9.2 in SAS Data Integration Studio, see SAS Note 43640.

Operating System and Release Information

A fix for this issue for SAS Management Console 9.1.3 is available at: