Previous Page | Next Page


Disabling a Cube

You can disable a cube by using the DISABLE CUBE statement. When you disable a cube, the server will not accept any new queries against that cube. Existing queries will continue to run to completion. In addition, the cube will not show up in the list of available cubes in the client session.

DISABLE CUBE cube-name|_ALL_;

The statement disallows new MDX queries which reference the specified cube (or all cubes if _ALL_ is specified). It does not terminate currently executing queries. Those queries will either finish on their own, or the sessions can be terminated using the CLOSE SESSION command. If a query is executed on a disabled cube, the following message is displayed.

cube cannot be opened

Previous Page | Next Page | Top of Page