Export (0) Print
Expand All

MDSCHEMA_MEASURES

SQL Server 2000

MDSCHEMA_MEASURES

This schema rowset describes each measure contained within a cube.

Microsoft® SQL Server™ 2000 Analysis Services extends the OLE DB specification with the addition of the following columns to this schema rowset.

Column name Type Description
MEASURE_IS_VISIBLE DBTYPE_BOOL Returns TRUE if dimension is visible.
LEVELS_LIST DBTYPE_WSTR Returns a comma-delimited list of unique names of the levels that are used in this measure. This column can be used for writeback when the end user needs to find out which levels can be written to for a virtual cube. If the measure is calculated, this column returns VT_NULL.
MEASURE_NAME_SQL_COLUMN_NAME DBTYPE_WSTR Returns the name of the column in the SQL query that corresponds to the measure's name.

Restriction Columns

CATALOG_NAME
SCHEMA_NAME
CUBE_NAME
MEASURE_NAME
MEASURE_UNIQUE_NAME

For more information about the MDSCHEMA_MEASURES schema rowset, see the OLE DB documentation.

Show:
© 2014 Microsoft