MDSCHEMA_CUBES Rowset
Describes the structure of cubes within a database.
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.
|
||
|
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. |
Note
The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, CUBE_NAME.
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. |
