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