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