Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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

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

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

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

LAST_UPDATED_BY

xsd:string

The name of the user who last updated the cube.

DESCRIPTION

xsd:string

A description of the cube.

IS_DRILLTHROUGH_ENABLED

xsd:boolean

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

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

PREFERRED_QUERY_PATTERNS

xsd:unsignedShort

No

A bitmask<177> 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.

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