You can disable a cube
by using the DISABLE CUBE statement. When you disable a cube, the
server does not accept any queries against that cube. Existing queries
continue to run to completion. In addition, the cube does not show
up in the list of available cubes in the client session.
DISABLE CUBE cube-name | _ALL_;
The statement disallows
new MDX queries that 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 statement.