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.
.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_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.
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.
|
Reference
OLE DB for OLAP Schema Rowsets
Help and Information
Getting SQL Server 2008 Assistance