Previous Page | Next Page


Refreshing a Cube

You can refresh a cube on an OLAP Server by using the REFRESH CUBE statement.

REFRESH CUBE cube-name |_ALL_;

The statement allows the server to access global calculated members and named sets that were defined or deleted since the cube header was loaded into the servers cube cache. This includes removing access to any global definitions which have been deleted since the server was started. If the _ALL_ keyword is specified, all cubes on the OLAP server are refreshed.

Note:   The REFRESH CUBE statement will not show changes to a cube that were made with the UPDATE_IN_PLACE or the ADD_DATA PROC OLAP option. You must disable and then enable a cube to see cube updates.  [cautionend]

Previous Page | Next Page | Top of Page