3.1.4.2.2.1.3.5.1 Columns

The MDSCHEMA_CUBES rowset contains the following columns.

Name

Type

Restriction

Description

CATALOG_NAME

xsd:string

Yes

The catalog name.

SCHEMA_NAME

xsd:string

Yes

The name of the schema.<221>

CUBE_NAME

xsd:string

Yes

The name of the cube.

CUBE_TYPE

xsd:string

The type of the cube.

Valid values are:

  • CUBE

  • DIMENSION

CUBE_GUID

uuid

The GUID of the cube.

CREATED_ON

xsd:dateTime

The date and time the cube was created.<222>

LAST_SCHEMA_UPDATE

xsd:dateTime

The date and time that the cube schema was last updated.

SCHEMA_UPDATED_BY

xsd:string

The name of the user who last updated the cube’s schema.<223>

LAST_DATA_UPDATE

xsd:dateTime

The date and time that the cube was last processed.

DATA_UPDATED_BY

xsd:string

The name of the user who last updated the data of the cube.<224>

DESCRIPTION

xsd:string

A description of the cube.

IS_DRILLTHROUGH_ENABLED

xsd:boolean

When true, indicates that the cube has drillthrough enabled; otherwise, false.<225>

IS_LINKABLE

xsd:boolean

When true, indicates that the cube can be used in a linked cube; otherwise false.

IS_WRITE_ENABLED

xsd:boolean

When true, indicates that the cube is write-enabled; otherwise false.

IS_SQL_ENABLED

xsd:boolean

When true, indicates that SQL can be used on the cube; otherwise false.

CUBE_CAPTION

xsd:string

The caption of the cube.

BASE_CUBE_NAME

xsd:string

Yes

The name of the source cube if this cube is a perspective cube.

CUBE_SOURCE

xsd:unsignedShort

Yes

A bitmask with one of these valid values:

  • 0x01-Cube

  • 0x02-Dimension<226>

PREFERRED_QUERY_PATTERNS

xsd:unsignedShort

No

A bitmask<227> that describes query pattern client applications can utilize for higher performance. Valid values are:

  • 0x00 – Use CrossJoin function to create symmetric sets on an axis. This is the default value for the 0th bit when Analysis Services is running in Traditional mode.

  • 0x01 – Use DrillDownMember to create a more restrictive, asymmetric axis. This is the default value for the 0th bit when a server that is running Analysis Services is running in VertiPaq mode.

  • 0x02 – Use to encourage implicit measures in a tabular model.<228> See [MS-SSAS-T] section 2.2.5.1.

  • 0x04 – Use the Union set optimization for MDX queries which involve multiple hierarchies.<229>

The rowset is sorted on CATALOG_NAME, SCHEMA_NAME, and CUBE_NAME.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:simpleType name="uuid">
         <xsd:restriction base="xsd:string">
           <xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-
                               [0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}" />
         </xsd:restriction>
       </xsd:simpleType>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="CATALOG_NAME" name="CATALOG_NAME" type="xsd:string" />
           <xsd:element sql:field="SCHEMA_NAME" name="SCHEMA_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="CUBE_NAME" name="CUBE_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="CUBE_TYPE" name="CUBE_TYPE" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="CUBE_GUID" name="CUBE_GUID" type="uuid" minOccurs="0" />
           <xsd:element sql:field="CREATED_ON" name="CREATED_ON" type="xsd:dateTime" 
                        minOccurs="0" />
           <xsd:element sql:field="LAST_SCHEMA_UPDATE" name="LAST_SCHEMA_UPDATE" 
                        type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="SCHEMA_UPDATED_BY" name="SCHEMA_UPDATED_BY" 
                        type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="LAST_DATA_UPDATE" name="LAST_DATA_UPDATE" 
                        type="xsd:dateTime" minOccurs="0" />
           <xsd:element sql:field="DATA_UPDATED_BY" name="DATA_UPDATED_BY" 
                        type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DESCRIPTION" name="DESCRIPTION" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="IS_DRILLTHROUGH_ENABLED" name="IS_DRILLTHROUGH_ENABLED" 
                        type="xsd:boolean" minOccurs="0" />
           <xsd:element sql:field="IS_LINKABLE" name="IS_LINKABLE" type="xsd:boolean" 
                        minOccurs="0" />
           <xsd:element sql:field="IS_WRITE_ENABLED" name="IS_WRITE_ENABLED" 
                        type="xsd:boolean" minOccurs="0" />
           <xsd:element sql:field="IS_SQL_ENABLED" name="IS_SQL_ENABLED" type="xsd:boolean" 
                        minOccurs="0" />
           <xsd:element sql:field="CUBE_CAPTION" name="CUBE_CAPTION" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="BASE_CUBE_NAME" name="BASE_CUBE_NAME" type="xsd:string" 
                        minOccurs="0" />
           <xsd:element sql:field="CUBE_SOURCE" name="CUBE_SOURCE" type="xsd:unsignedShort" 
                        minOccurs="0" />
           <xsd:element sql:field="PREFERRED_QUERY_PATTERNS" 
                        name="PREFERRED_QUERY_PATTERNS" 
                        type="xsd:unsignedShort" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>
  • Last updated on