TechNet
Export (0) Print
Expand All

MDSCHEMA_CUBES Rowset

 

Applies To: SQL Server 2016 Preview

Describes the structure of cubes within a database.

The MDSCHEMA_CUBES rowset contains the following columns.

Column nameType indicatorDescription
CATALOG_NAMEDBTYPE_WSTRThe name of the database.
SCHEMA_NAMEDBTYPE_WSTRNot supported.
CUBE_NAMEDBTYPE_WSTRThe name of the cube or dimension. Dimension names are prefaced by a dollar sign ($) symbol.

Note: Only server and database administrators have permissions to see cubes created from a dimension.
CUBE_TYPEDBTYPE_WSTRThe type of the cube. Valid values are:

 CUBE

 DIMENSION
CUBE_GUIDDBTYPE_GUIDNot supported.
CREATED_ONDBTYPE_DBTIMESTAMPNot supported.
LAST_SCHEMA_UPDATEDBTYPE_DBTIMESTAMPThe time that the cube was last processed.
SCHEMA_UPDATED_BYDBTYPE_WSTRNot supported.
LAST_DATA_UPDATEDBTYPE_DBTIMESTAMPThe time that the cube was last processed.
DATA_UPDATED_BYDBTYPE_WSTRNot supported.
DESCRIPTIONDBTYPE_WSTRA user-friendly description of the cube.
IS_DRILLTHROUGH_ENABLEDDBTYPE_BOOLA Boolean that always returns true.
IS_LINKABLEDBTYPE_BOOLA Boolean that indicates whether a cube can be used in a linked cube.
IS_WRITE_ENABLEDDBTYPE_BOOLA Boolean that indicates whether a cube is write-enabled.
IS_SQL_ENABLEDDBTYPE_BOOLA Boolean that indicates whether SQL can be used on the cube.
CUBE_CAPTIONDBTYPE_WSTRThe caption of the cube.
BASE_CUBE_NAMEDBTYPE_WSTRThe name of the source cube if this cube is a perspective cube.
ANNOTATIONSDBTYPE_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 nameType indicatorRestriction State
CATALOG_NAMEDBTYPE_WSTROptional.
SCHEMA_NAMEDBTYPE_WSTROptional.
CUBE_NAMEDBTYPE_WSTROptional.
CUBE_SOURCEDBTYPE_UI2(Optional) Default restriction is a value of 1. A bitmap with one of these valid values:

1 CUBE

2 DIMENSION
Base Cube_NameDBTYPE_WSTROptional.

OLE DB for OLAP Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft