After a cube is created, it might be necessary to make
changes to the cube. Whether you need to change a cube that exists
only as metadata or has physical files built, you can modify the cube
with the Edit Cube Structure function. This function launches the
Cube Designer wizard, where you can make various changes to the cube
including the following:
-
changing the source data for the
cube
-
adding or removing structural data
to the cube (dimensions, levels, hierarchies)
-
changing properties for cube components
(level properties, measure attributes, and so on)
-
adding or removing cube measures,
member properties, or aggregations
The Cube Designer wizard
gives you the opportunity to edit and build the cube based on the
existing cube metadata. When you are finished making changes to the
cube in the Cube Designer wizard, you can choose to update the metadata
or update the metadata and build the cube.
To access the Edit Cube
Structure function, select the cube that you need to edit in the SAS
OLAP Cube Studio tree view. Then select
Edit Cube Structure from the
Actions menu or from the cube's
context menu. This opens the Cube Designer wizard. The selected cube
is opened and can now be edited.