Export (0) Print
Expand All

XML for Analysis Schema Rowsets

The Microsoft XML for Analysis (XMLA) provider includes schema rowsets that return metadata about server state, activity, and objects. Retrieving metadata is necessary if you are developing a client application that connects to an Analysis Services model whose structure and characteristics are variable.

Schema rowsets also provide insight into internal processes and operations that can help you monitor the server and troubleshoot problems. To better support ad hoc administrative tasks, you can run a Dynamic Management View (DMV) query against most schema rowsets. DMV queries return results in a readable, tabular format that you can view in Management Studio.

The following table lists and describes each XMLA schema rowset, and identifies whether it returns information specific to tabular data models.

Rowset1

Description

DISCOVER_CALC_DEPENDENCY Rowset

Returns information about dependencies among tables, columns, measures, and calculated column formulas.

Applies to tabular models deployed on an Analysis Services instance and PowerPivot models in Excel workbooks that run in a SharePoint environment.

DISCOVER_CONNECTIONS Rowset

Provides resource usage and activity information about the currently opened connections on the server.

DISCOVER_COMMAND_OBJECTS Rowset

Provides resource usage and activity information about the objects in use by the referenced command.

DISCOVER_COMMANDS Rowset

Provides resource usage and activity information about the currently executing or last executed commands in the opened connections on the server

DISCOVER_CSDL_METADATA Rowset

Returns an XML definition of a data source to a client that can consume a tabular or PowerPivot model, and present the source data as part of a report.

Applies to tabular models deployed on an Analysis Services instance and PowerPivot models in Excel workbooks that run in a SharePoint environment.

DISCOVER_DATASOURCES Rowset

Returns a list of the XMLA Provider data sources that are available on the server or Web service.

DISCOVER_DB_CONNECTIONS Rowset

Provides resource usage and activity information about the currently opened connections from the server to a database.

DISCOVER_DIMENSION_STAT Rowset

Returns statistics on the specified dimension.

DISCOVER_ENUMERATORS Rowset

Returns a list of names, data types, and enumeration values of enumerators supported by the XMLA Provider for a specific data source.

DISCOVER_JOBS Rowset

Provides information about the active jobs executing on the server.

DISCOVER_KEYWORDS Rowset (XMLA)

Returns information about keywords reserved by the XMLA provider.

DISCOVER_LITERALS Rowset

Returns information about literals, including data types and values, supported by the XMLA provider.

DISCOVER_LOCATIONS Rowset

Returns information about the contents of a backup file.

DISCOVER_LOCKS Rowset

Provides information about the current standing locks on the server.

DISCOVER_MEMORYGRANT Rowset

Returns a list of internal memory quota grants that are taken by jobs that are currently running on the server.

DISCOVER_MEMORYUSAGE Rowset

Returns the memory usage statistics for various objects allocated by the server.

DISCOVER_OBJECT_ACTIVITY Rowset

Provides resource usage per object since the start of the service.

DISCOVER_OBJECT_MEMORY_USAGE Rowset

Provides information about memory resources used by objects.

DISCOVER_PARTITION_DIMENSION_STAT Rowset

Returns statistics on the dimension that is associated with a partition.

DISCOVER_PARTITION_STAT Rowset

Returns statistics on aggregations in a particular partition.

DISCOVER_PERFORMANCE_COUNTERS Rowset

Returns the value of one or more specified performance counters.

DISCOVER_PROPERTIES Rowset

Returns a list of information and values about the standard and provider-specific properties that are supported by the XMLA provider for the specified data source.

DISCOVER_SCHEMA_ROWSETS Rowset

Returns the names, restrictions, description, and other information for all enumeration values and any additional provider-specific enumeration values supported by the XMLA provider.

DISCOVER_SESSIONS Rowset

Provides resource usage and activity information about the currently opened sessions on the server.

DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS Rowset

Provides information at the column and segment level about storage tables used by a tabular or PowerPivot database.

Applies to tabular models deployed on an Analysis Services instance and PowerPivot models in Excel workbooks that run in a SharePoint environment.

DISCOVER_STORAGE_TABLE_COLUMNS Rowset

Allows the client to determine the assignment of columns to storage tables used by a tabular or PowerPivot database.

Applies to tabular models deployed on an Analysis Services instance and PowerPivot models in Excel workbooks that run in a SharePoint environment.

DISCOVER_STORAGE_TABLES Rowset

Returns information about the tables used in a model.

Applies to tabular models deployed on an Analysis Services instance and PowerPivot models in Excel workbooks that run in a SharePoint environment.

DISCOVER_TRACE_COLUMNS Rowset

Describes the trace columns provided by the trace provider.

DISCOVER_TRACE_DEFINITION_PROVIDERINFO Rowset

Returns basic information about the trace provider, such as its name and description.

DISCOVER_TRACE_EVENT_CATEGORIES Rowset

Describes the event categories provided by the trace provider.

DISCOVER_TRACES Rowset

Returns information about traces running on a server.

DISCOVER_TRANSACTIONS Rowset

Returns the current set of pending transactions on the system.

DISCOVER_XML_METADATA Rowset

Returns an XML document describing a requested object.

1 All the schema rowsets listed here are supported by the MSOLAP data source provider for the Microsoft XMLA Provider.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft