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:
-
Open SAS Management
Console.
-
Expand the SAS OLAP
Server Monitor.
-
Expand the OLAP schema
that contains the cube.
-
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.