OpenQueryLogRecordset

The OpenQueryLogRecordset method of an object of ClassType clsCubeAnalyzer returns a Microsoft® ActiveX® Data Objects (ADO DB) recordset containing a record for each OLAP query run on the OLAP server that satisfies the given SQL query.

Syntax

ADODBRecSet = dsoCubeAnalyzer.OpenQueryLogRecordset(SQLString As String)

ADODBRecSet
An ADODB recordset.
dsoCubeAnalyzer
The object of ClassType clsCubeAnalyzer used.
SQLString
The SQL query that returns the desired QueryLogRecordset. You can generate an SQL statement using any of the fields in the query log. For example,

"SELECT * FROM  QueryLog WHERE Duration > 5"

The following columns are returned in ADODBRecSet.

Column DataType Description
MSOLAP_Database Text The name of the database used in the query.
MSOLAP_Cube Text The name of the cube used in the query.
MSOLAP_User Text The name of the user that ran the query.
Dataset Text A numeric string indicating the level from each dimension used to satisfy the query.
StartTime Data/Time The time the query began.
Duration Number The length of time (in seconds) of the query execution.
MOLAPPartitions Number The number of aggregations used to satisfy the query.
ROLAPPartitions Number The number of aggregations used to satisfy the query.
SamplingRate Number The sampling rate at the time the query was executed.

Remarks

In order to create an instance of the ADODB Recordset object, you must add the ActiveX Data Objects reference to your Microsoft Visual Basic® project.

See Also

Using Decision Support Objects

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.