APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

Provides information at the column and segment level about storage tables used by an Analysis Services database running in tabular or Power Pivot mode. This rowset is primarily used for troubleshooting and analysis.

Applies to: tabular models

Rowset Columns

The DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS rowset contains the following columns.

Column name Type indicator Restriction Description
DATABASE_NAME DBTYPE_WSTR Yes Specifies the tabular database.

The DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS rowset can be restricted by using this column. If omitted the current database is used.
CUBE_NAME DBTYPE_WSTR Yes The name of the model.

The DISCOVER_STORAGE_TABLES rowset can be restricted by using this column.
MEASURE_GROUP_NAME DBTYPE_WSTR Yes The name of the measure group.
PARTITION_NAME DBTYPE_WSTR Yes The name of the partition.
DIMENSION_NAME DBTYPE_WSTR The name of the dimension.
TABLE_ID DBTYPE_WSTR The internal ID of the table segment.
COLUMN_ID DBTYPE_WSTR The internal ID of the column.
SEGMENT _NUMBER DBTYPE_I8 The ordinal number of the table segment.
TABLE_PARTTION_NUMBER DBTYPE_I8 The ordinal number of the partition.
RECORDS_COUNT DBTYPE_I8 The number of records in the partition.
ALLOCATED_SIZE DBTYPE_UI8 Size in bytes allocated to the column segment.
USED_SIZE DBTYPE_UI8 Size in bytes used by the column segment.
COMPRESSION_TYPE DBTYPE_WSTR Type of compression applied to the column segment. This value is intended for internal use and customer support use only. Microsoft does not publish valid values or descriptions for this column.
BITS_COUNT DBTYPE_I8 The count of bits.
BOOKMARK_BITS_COUNT DBTYPE_I8 The count of bookmark bits.
VERTIPAQ_STATE DBTYPE_WSTR The state of the VertiPaq compression for this column segment. The value is one of the following:

SKIPPED – The VertiPaq compression was skipped.

COMPLETED – The VertiPaq compression completed successfully.

TIMEBOXED – The VertiPaq compression was timeboxed.

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 a07ccd45-8148-11d0-87bb-00c04fc33942
ADOMDNAME StorageSegments


The following query returns the storage table segments associated with the model attribute LastName, in the current database.

WHERE COLUMN_ID = 'LastName'  

See Also

Analysis Services Schema Rowsets