Enabling and Disabling Cubes for a Cube Update

After a cube has been updated, the updates can be seen only after all open queries have finished using the cube. After that, the next open query displays the new updates. In a busy environment, with numerous sessions, this could take considerable time. Executing the DISABLE and then ENABLE statements forces new queries 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 about updating cubes, see Updating SAS OLAP Cubes and the ADD_DATA PROC OLAP option.