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.<211> |
CUBE_NAME |
xsd:string |
Yes |
The name of the cube. |
CUBE_TYPE |
xsd:string |
|
The type of the cube. Valid values are:
|
CUBE_GUID |
uuid |
|
The GUID of the cube. |
CREATED_ON |
xsd:dateTime |
|
The date and time the cube was created.<212> |
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.<213> |
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.<214> |
DESCRIPTION |
xsd:string |
|
A description of the cube. |
IS_DRILLTHROUGH_ENABLED |
xsd:boolean |
|
When true, indicates that the cube has drillthrough enabled; otherwise, false.<215> |
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:
|
PREFERRED_QUERY_PATTERNS |
xsd:unsignedShort |
No |
A bitmask<217> that describes query pattern client applications can utilize for higher performance. Valid values are:
|
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>