Applies To: SQL Server 2016 Preview

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

The DISCOVER_DIMENSION_STAT rowset contains the following columns.

Column nameType indicatorRestrictionDescription
DATABASE_NAMEDBTYPE_WSTRRequiredThe name of the database that contains the dimension.

This column is required in the restriction list.
DIMENSION_NAMEDBTYPE_WSTRRequiredThe name of the dimension.

This column is required in the restriction list.
ATTRIBUTE_NAMEDBTYPE_WSTRThe name of an attribute in the dimension.
ATTRIBUTE_COUNTDBTYPE_I8The 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.

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.


XML for Analysis Schema Rowsets

Community Additions