Importing and Exporting SAS OLAP Cubes

Overview

Companies that create and use SAS OLAP cubes often have more than one environment that they store cubes on. A company might have an environment for developing and building cubes, another environment for testing cubes, and finally a production environment where cubes are accessed and queried by end users. If you have multiple environments for SAS OLAP cubes, you need the ability to copy cubes and their supporting files and objects from one environment to another.

Determining Which Tool to Use

SAS 9.2 offers you different options to move your data from SAS 9.1.3 SP4. When you choose to copy or move SAS OLAP cubes between SAS environments, consider the following options for moving your cubes:

Cubes that were built with a version of SAS that is earlier than 9.2 can be moved to the SAS 9.2 environment by using the ExportCubes and ImportCubes batch tools.

Export SAS Package and Import SAS Package

Cubes built with SAS OLAP Cube Studio 4.2 can be copied or moved between SAS 9.2 systems with the Export SAS Package and Import SAS Package functions that are part of SAS OLAP Cube Studio 4.2.