The OLAPOPERATE Procedure

Listing Session Rowsets on an OLAP Server

You can list information about session queries with the LIST ROWSETS statement.

If the SESSION option is specified, then the rowsets associated with a particular user are listed. Otherwise, all rowsets are listed. If the OUT option is specified, the output is written to the specified data set. The LIST ROWSETS statement is available only for SAS 9.2 or later OLAP servers. It is not available for OLAP servers prior to SAS 9.2.

LIST ROWSETS [SESSION=owner] [OUT=data-set];

The LIST ROWSETS statement generates the following information:

Cube names: lists the names of the cubes opened in this rowset.

Last Update Time: indicates the last time the rowset was accessed. For example, a rowset is considered to be accessed when a method call such as ReadRows is made against it.

Number of open cubes: indicates the number of cubes opened in this rowset.

Rowset ID: is the rowset ID.

Rowset name

indicates the type name of the rowset. The following are possible values for Rowset name.

ACTIONSET
CATALOGSET
CUBESET
DIMENSIONSET
FUNCTIONSET
HIERARCHYSET
LEVELSET
MEMBERSET
MEASURESET
PROPERTYSET
SCHEMASET
SETSET

Here is an output example for LIST ROWSETS (this command is available only when connected to a SAS 9.2 or later OLAP server):

Rowset name "CUBESET"
Rowset ID: 9793404A-D046-4CF0-A7ED-EE0F1BB643A6
The time of last rowset access is 12Apr2011:11:20:51

Rowset name "DIMENSIONSET"
Rowset ID: 66D02B81-2F92-464F-8782-7516E67493F4
The time of last rowset access is 12Apr2011:11:20:54
Cube CENSUSCMR is being accessed by this rowset.