Export (0) Print
Expand All
0 out of 3 rated this helpful - Rate this topic

DISCOVER_PARTITION_STAT Rowset

SQL Server 2012

Returns statistics on aggregations in a particular partition.

Applies to: tabular models, multidimensional models

The DISCOVER_PARTITION_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.

CUBE_NAME

DBTYPE_WSTR

Required

The name of the cube or tabular model that contains the partition.

This column is required in the restriction list.

MEASURE_GROUP_NAME

DBTYPE_WSTR

Required

The name of a measure group in the dimension.

This column is required in the restriction list.

PARTITION_NAME

DBTYPE_WSTR

Required

The name of a partition.

This column is required in the restriction list.

AGGREGATION_NAME

DBTYPE_WSTR

The name of the aggregation.

AGGREGATION_SIZE

DBTYPE_I8

The size of the aggregation.

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.

Argument

Value

GUID

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

ADOMDNAME

PartitionStat

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.