MDSCHEMA_CUBES Rowset
Describes the structure of cubes within a database.
Rowset Columns
The MDSCHEMA_CUBES rowset contains the following columns.
Column name
Type indicator
Length
Description
CATALOG_NAME
DBTYPE_WSTR
The name of the database.
SCHEMA_NAME
DBTYPE_WSTR
Not supported.
CUBE_NAME
DBTYPE_WSTR
The name of the cube or dimension. Dimension names are prefaced by a dollar sign ($) symbol.
.gif "ms126271.note(en-US,SQL.90).gif")
Note:
Only server and database administrators have permissions to see cubes created from a dimension.
CUBE_TYPE
DBTYPE_WSTR
The type of the cube. Valid values are:
- CUBE
- DIMENSION
CUBE_GUID
DBTYPE_GUID
Not supported.
CREATED_ON
DBTYPE_DBTIMESTAMP
Not supported.
LAST_SCHEMA_UPDATE
DBTYPE_DBTIMESTAMP
The time that the cube was last processed.
SCHEMA_UPDATED_BY
DBTYPE_WSTR
Not supported.
LAST_DATA_UPDATE
DBTYPE_DBTIMESTAMP
The time that the cube was last processed.
DATA_UPDATED_BY
DBTYPE_WSTR
Not supported.
DESCRIPTION
DBTYPE_WSTR
A user-friendly description of the cube.
IS_DRILLTHROUGH_ENABLED
DBTYPE_BOOL
A Boolean that always returns true.
IS_LINKABLE
DBTYPE_BOOL
A Boolean that indicates whether a cube can be used in a linked cube.
IS_WRITE_ENABLED
DBTYPE_BOOL
A Boolean that indicates whether a cube is write-enabled.
IS_SQL_ENABLED
DBTYPE_BOOL
A Boolean that indicates whether SQL can be used on the cube.
CUBE_CAPTION
DBTYPE_WSTR
The caption of the cube.
BASE_CUBE_NAME
DBTYPE_WSTR
The name of the source cube if this cube is a perspective cube.
ANNOTATIONS
DBTYPE_WSTR
(Optional) A set of notes, in XML format.
The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME.
Restriction Columns
The MDSCHEMA_CUBES rowset can be restricted on the columns listed in the following table.
| Column name | Type indicator | Restriction State |
|---|---|---|
CATALOG_NAME |
DBTYPE_WSTR |
Optional. |
SCHEMA_NAME |
DBTYPE_WSTR |
Optional. |
CUBE_NAME |
DBTYPE_WSTR |
Optional. |
CUBE_SOURCE |
DBTYPE_UI2 |
(Optional) A bitmap with one of these valid values:
Default restriction is a value of 1. |
Base Cube_Name |
DBTYPE_WSTR |
Optional. |
See Also
Reference
OLE DB for OLAP Schema Rowsets