Importing and Exporting SAS OLAP Cubes: Importing and Exporting SAS OLAP Cubes

Importing and Exporting SAS OLAP Cubes

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:

ExportCubes and ImportCubes Batch Tools	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.

Top of Page