Previous Page | Next Page


Enabling and Disabling Cubes for a Cube Update

After a cube has been updated, the updates can be seen only after all open sessions have finished using the cube. After that, the next open session will display the new updates. In a busy environment, with numerous sessions, this could take considerable time. Executing the DISABLE and then ENABLE statements forces new sessions to immediately access the new data. In addition, if a cube is actively being queried. it must be disabled before you can use the DELETE or DELETE_PHYSICAL PROC OLAP options. For more information on updating cubes, see Updating SAS OLAP Cubes and the ADD_DATAPROC OLAP option.

Previous Page | Next Page | Top of Page