Export (0) Print
Expand All

MDSCHEMA_CUBES Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

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

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:
© 2015 Microsoft