Listing Session Cubes on an OLAP Server

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.