Export (0) Print
Expand All

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.

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

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:

  • 1 CUBE

  • 2 DIMENSION

Default restriction is a value of 1.

Base Cube_Name

DBTYPE_WSTR

Optional.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft