Analysis Services Programming
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.