Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |