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. 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_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. |