DISCOVER_DIMENSION_STAT Rowset

Provides information about a dimension, including the name of the database that contains it, the dimension name, its attributes, and a count of the members for each attribute. In a tabular model, this corresponds to the columns in a table, and the number of values in each column.

Applies to: tabular models, multidimensional models

Rowset Columns

The DISCOVER_DIMENSION_STAT rowset contains the following columns.

Column name

Type indicator

Restriction

Description

DATABASE_NAME

DBTYPE_WSTR

Required

The name of the database that contains the dimension.

This column is required in the restriction list.

DIMENSION_NAME

DBTYPE_WSTR

Required

The name of the dimension.

This column is required in the restriction list.

ATTRIBUTE_NAME

DBTYPE_WSTR

 

The name of an attribute in the dimension.

ATTRIBUTE_COUNT

DBTYPE_I8

 

The count of values in the named attribute. For a tabular model, the value is always the same as the number of rows in the table.

This schema rowset is not sorted.

Using ADOMD.NET to return the rowset

When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.

The following table provides the GUID and string values that identify this rowset.

Argument

Value

GUID

a07ccd90-8148-11d0-87bb-00c04fc33942

ADOMDNAME

PartitionDimensionStat

See Also

Reference

XML for Analysis Schema Rowsets