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