Administering SAS OLAP Servers

Coalescing Cubes

Coalescing a cube combines all of the generation folders from previous versions of the cube into a single generation folder in the latest version of the cube. The old generation folders are deleted. The generation folders that are combined and deleted are those that were produced after the last time you coalesced the cube.

To coalesce a cube, follow these steps:

Disable the cube with SAS OLAP Cube Studio or with PROC OLAPOPERATE, or follow these steps:
1. Open SAS Management Console.
2. Expand the SAS OLAP Server Monitor.
3. Expand the OLAP schema that contains the cube.
4. Right-click the cube and select Disable.
For more information about OLAPOPERATE and SAS OLAP Cube Studio, see the SAS OLAP Server: User's Guide.
Close all open sessions on the cube by running PROC OLAPOPERATE programs for each SAS OLAP Server that supports queries on that cube, or by displaying and closing sessions in SAS OLAP Server Monitor.
Coalesce the cube using the COALESCE option in PROC OLAP.
When the coalesce operation is complete, enable the cube.

Top of Page