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.

Remarque :

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.

Voir aussi

Référence

OLE DB for OLAP Schema Rowsets

Aide et Informations

Assistance sur SQL Server 2005