Modifying and Maintaining Cubes

Disabling and Enabling Cubes

In SAS OLAP Cube Studio, you can disable and enable cubes to perform various cube changes and adjustments. You can disable a SAS OLAP cube if you need to perform administrative tasks or make edits to the cube. You might disable a cube to perform the following tasks:

tuning cube aggregations
adding calculated members to a cube
changing the security settings for a cube
renaming a cube
editing and rebuilding a cube
changing the OLAP schema for a cube

Disabling a cube removes it from production. As a result, queries against the cube are affected. Queries that are currently running against the cube are completed. However, new queries against the cube are not accepted by the OLAP server. To disable a cube in SAS OLAP Cube Studio, select a cube from the tree view. Then select Disable from either the Actions menu or the cube's context menu. The cube is then disabled in the tree view.

Note: You must have Administer permissions on the OLAP server to disable a cube. For more information on permissions, see the SAS Intelligence Platform: Security Administration Guide. [cautionend]

Enabling Cubes

You can enable a SAS OLAP cube that you have previously disabled. A cube is disabled in order make edits to the cube or to perform administrative tasks on the cube. Enabling a cube brings it into production, so that new queries against the cube are accepted by the OLAP Server. In order to enable a cube in SAS OLAP Cube Studio, select a disabled cube from the tree view. Then select Enable from either the Actions menu or the cube's context menu. The cube is then enabled and listed as an enabled cube in the tree view.

After the cube is enabled, you can resume queries to the cube that require SAS OLAP Server sessions. In SAS OLAP Cube Studio, you can also use the View Cube function.

Note: You must have Administer permissions on the OLAP server to enable a cube. For more information on permissions, see the SAS Intelligence Platform: Security Administration Guide. [cautionend]

Top of Page