MDSCHEMA_DIMENSIONS rowset

DIMENSIONS rowsetには指定されたキューブの次元に関する情報が含まれます。各次元には1つの行があります。

GUID: MDSCHEMA_DIMENSIONS

表34で、このrowset構造体について説明します。

表 34. MDSCHEMA_DIMENSIONS rowset構造体

列名

Essbaseマッピング

CATALOG_NAME

アプリケーション名

CUBE_NAME

データベース名

DIMENSION_NAME

次元名

DIMENSION_UNIQUE_NAME

次元名

DIMENSION_CAPTION

次元名

DIMENSION_ORDINAL

次元番号。最初の次元が1、次が2と続きます

DIMENSION_TYPE

Essbase次元タイプ:

  • 時間: MD_DIMTYPE_TIME

  • 勘定科目: MD_DIMTYPE_MEASURE

  • その他: MD_DIMTYPE_OTHER

DIMENSION_CARDINALITY

次元内のメンバー数

DEFAULT_HIERARCHY

次元名

DESCRIPTION

次元に追加されたコメント

DIMENSION_UNIQUE_SETTINGS

2

DIMENSION_IS_VISIBLE

常にTRUE

要求の例 

      <SOAP-ENV:Envelope
 xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
 xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance"
 xmlns:xsd="http://www.w3.org/2001/XMLSchema">
 <SOAP-ENV:Body>
  <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
   SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <RequestType>MDSCHEMA_DIMENSIONS</RequestType>
    <Restrictions>
     <RestrictionList>
      <CATALOG_NAME>Sample</CATALOG_NAME>
      <CUBE_NAME>Basic</CUBE_NAME>
     </RestrictionList>
    </Restrictions>
    <Properties>
     <PropertyList>
      <DataSourceInfo>Provider=Essbase;Data Source=localhost
      </DataSourceInfo>
      <Format>Tabular</Format>
     </PropertyList>
    </Properties>
  </Discover>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

応答の例(抜粋)

      <?xml version="1.0"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" 
 SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
 <SOAP-ENV:Body>
  <m:DiscoverResponse xmlns:m="urn:schemas-microsoft-com:xml-analysis">
   <m:return xsi:type="xsd:string" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
    xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
          xmlns:xsd="http://www.w3.org/2001/XMLSchema">
     <xsd:schema xmlns="urn:schemas-microsoft-com:xml-analysis:rowset"
      targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" 
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
      xmlns:xsd="http://www.w3.org/2001/XMLSchema"
      xmlns:sql="urn:schemas-microsoft-com:xml-sql"
      elementFormDefault="qualified">
      <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:complexType name="row">
      <xsd:sequence maxOccurs="unbounded" minOccurs="0">
       <xsd:element name="CATALOG_NAME" type="xsd:string" 
        sql:field="CATALOG_NAME"/>
       <xsd:element name="CUBE_NAME" type="xsd:string" 
        sql:field="CUBE_NAME"/>
       <xsd:element name="DIMENSION_NAME" type="xsd:string" 
        sql:field="DIMENSION_NAME"/>
       <xsd:element name="DIMENSION_UNIQUE_NAME" type="xsd:string" 
        sql:field="DIMENSION_UNIQUE_NAME"/>
       <xsd:element name="DIMENSION_CAPTION" type="xsd:string" 
        sql:field="DIMENSION_CAPTION"/>
       <xsd:element name="DIMENSION_ORDINAL" type="xsd:unsignedInt" 
        sql:field="DIMENSION_ORDINAL"/>
       <xsd:element name="DIMENSION_TYPE" type="xsd:short" 
        sql:field="DIMENSION_TYPE"/>
       <xsd:element name="DIMENSION_CARDINALITY" type="xsd:unsignedInt" 
        sql:field="DIMENSION_CARDINALITY"/>
       <xsd:element name="DEFAULT_HIERARCHY" type="xsd:string" 
        sql:field="DEFAULT_HIERARCHY"/>
       <xsd:element name="DESCRIPTION" type="xsd:string" 
        sql:field="DESCRIPTION" minOccurs="0"/>
       <xsd:element name="DIMENSION_UNIQUE_SETTINGS" type="xsd:int" 
        sql:field="DIMENSION_UNIQUE_SETTINGS"/>
       <xsd:element name="DIMENSION_IS_VISIBLE" type="xsd:boolean" 
        sql:field="DIMENSION_IS_VISIBLE"/>
      </xsd:sequence>
     </xsd:complexType>
    </xsd:schema>
    <row>
     <CATALOG_NAME>Sample</CATALOG_NAME>
     <CUBE_NAME>Sample.Basic</CUBE_NAME>
     <DIMENSION_NAME>Year</DIMENSION_NAME>
     <DIMENSION_UNIQUE_NAME>[Year]</DIMENSION_UNIQUE_NAME>
     <DIMENSION_CAPTION>Year</DIMENSION_CAPTION> 
     <DIMENSION_ORDINAL>1</DIMENSION_ORDINAL>
     <DIMENSION_TYPE>1</DIMENSION_TYPE>
     <DIMENSION_CARDINALITY>19</DIMENSION_CARDINALITY>
     <DEFAULT_HIERARCHY>[Year]</DEFAULT_HIERARCHY>
     <DIMENSION_UNIQUE_SETTINGS>2</DIMENSION_UNIQUE_SETTINGS>
     <DIMENSION_IS_VISIBLE>true</DIMENSION_IS_VISIBLE>
    </row>
    < ................More Rows............. >
   </root>
  </m:return>
 </m:DiscoverResponse>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>