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 queries are listed. The LIST ROWSETS statement is only available for SAS 9.2 OLAP servers. It is not available for OLAP servers prior to SAS 9.2.

LIST ROWSETS [SESSION=owner];

The LIST ROWSETS statement generates the following statistics:

Cube names

lists the names of the cubes opened in this rowset.

Last Update Time

indicates the last time the rowset was referenced.

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 statistic.

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

Here are some examples of session rowset output from an OLAP server.

Rowset name "CUBESET"
Rowset ID: 09FDD38D-237C-42AD-BD92-1126ADEC7046
The time of last rowset access is 13Nov2007:14:03:40

Rowset name "DIMENSIONSET"
Rowset ID: E9B538AA-D80E-40E5-9FD2-8C374EE1B37F
The time of last rowset access is 13Nov2007:14:03:41
Cube MAILORDERINFO is being accessed by this rowset.

Top of Page