You can list information
about session cubes using the LIST CUBES statement.
LIST CUBES [CUBE=cube-name] [OUT=data-set];
If the CUBE option is
specified, then only information about the specified cube is listed.
Otherwise, all cubes are listed. If the OUT option is specified,
the output is written to the specified data set.
The LIST CUBES statement
generates the following information:
- Cube name
-
is the name of the
cube.
- Cube status
-
indicates the status
of the cube (enabled or disabled).
- Number of open result sets
-
lists the number of
open result sets using this cube.
Note: The LIST CUBES command is
available only for clients connecting to a SAS 9.2 or later version
of the OLAP server.
Connection OptionsDisconnecting from an OLAP ServerListing Active Sessions on an OLAP ServerListing Session Queries on an OLAP ServerListing Session Rowsets on an OLAP ServerListing Session Cubes on an OLAP Server Closing a SessionCanceling a Query Result SetDisabling a CubeEnabling a CubeEnabling and Disabling Cubes for a Cube UpdateRefreshing a CubeStopping an OLAP ServerQuiescing an OLAP Server Pausing an OLAP Server Resuming an OLAP Server