Previous Page | Next Page

Updating SAS OLAP Cubes

Overview

After a SAS OLAP cube is created, it might be necessary to add further data to the cube without completely re-creating the cube. If a cube is in production, you must consider what the best process to update your cube is. You should also consider an approach that will have as little impact as possible on users. It is important to limit the amount of time that a cube is unavailable to users while the cube is being updated with new data. It is also important that the updated cube be checked for correctness before the cube is made available for queries. To address these concerns, you can choose either to update a SAS OLAP cube in-place or to create an incremental copy of the cube.

You can update SAS OLAP cubes that physically exist and that are generated from either detail tables or star schemas. You cannot update a fully summarized cube. Furthermore you must have ReadMetadata and WriteMetadata permissions for all elements of the cube

New data to add to a cube can include new members and new data for the cube or additional data for existing members. You can update a cube using SAS OLAP Cube Studio or manually using PROC OLAPand PROC OLAPOPERATE.

Previous Page | Next Page | Top of Page