MDSCHEMA_MEMBERS rowset

MEMBERS rowsetは使用できるメンバーに関する情報を含んでいます。

GUID: MDSCHEMA_MEMBERS

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

表 38. MDSCHEMA_MEMBERS rowset構造体

列名

Essbaseマッピング

CATALOG_NAME

アプリケーション名

CUBE_NAME

データベース名

DIMENSION_UNIQUE_NAME

次元名

HIERARCHY_UNIQUE_NAME

次元名

LEVEL_UNIQUE_NAME

レベル名

LEVEL_NUMBER

レベル番号

GENERATION_NUMBER

世代番号

MEMBER_ORDINAL

メンバー番号

MEMBER_NAME

メンバー名

MEMBER_UNIQUE_NAME

一意のメンバー名

MEMBER_TYPE

1(通常)

MEMBER_CAPTION

メンバー名

MEMBER_ALIAS

デフォルトの別名

CHILDREN_CARDINALITY

子の数

PARENT_LEVEL

親のレベル番号。次元については、次元レベル番号と同じレベル番号

PARENT_UNIQUE_NAME

親の名前。次元については、次元名と同じ名前

PARENT_COUNT

常に1

DESCRIPTION

メンバーのコメント

要求の例 

      <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"
 xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">
 <SOAP-ENV:Header>
   <wsse:Security>
    <wsse:UsernameToken>
      <wsse:Username>system</wsse:Username>
      <wsse:Password>password</wsse:Password>
    </wsse:UsernameToken>
   </wsse:Security>
 </SOAP-ENV:Header>
 <SOAP-ENV:Body>
  <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
   SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
   <RequestType>MDSCHEMA_MEMBERS</RequestType>
   <Restrictions>
    <RestrictionList>
     <CATALOG_NAME>Sample</CATALOG_NAME>
     <CUBE_NAME>Basic</CUBE_NAME>
     <DIMENSION_UNIQUE_NAME>Year</DIMENSION_UNIQUE_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_UNIQUE_NAME" type="xsd:string" 
            sql:field="DIMENSION_UNIQUE_NAME"/>
           <xsd:element name="HIERARCHY_UNIQUE_NAME" type="xsd:string" 
            sql:field="HIERARCHY_UNIQUE_NAME"/>
           <xsd:element name="LEVEL_UNIQUE_NAME" type="xsd:string" 
            sql:field="LEVEL_UNIQUE_NAME"/>
           <xsd:element name="LEVEL_NUMBER" type="xsd:unsignedInt" 
            sql:field="LEVEL_NUMBER"/>
           <xsd:element name="GENERATION_NUMBER" type="xsd:unsignedInt" 
            sql:field="GENERATION_NUMBER"/>
           <xsd:element name="MEMBER_ORDINAL" type="xsd:unsignedInt" 
            sql:field="MEMBER_ORDINAL"/>
           <xsd:element name="MEMBER_NAME" type="xsd:string" 
            sql:field="MEMBER_NAME"/>
           <xsd:element name="MEMBER_UNIQUE_NAME" type="xsd:string" 
            sql:field="MEMBER_UNIQUE_NAME"/>
           <xsd:element name="MEMBER_TYPE" type="xsd:int" 
            sql:field="MEMBER_TYPE"/>
           <xsd:element name="MEMBER_CAPTION" type="xsd:string" 
            sql:field="MEMBER_CAPTION"/>
           <xsd:element name="MEMBER_ALIAS" type="xsd:string" 
            sql:field="MEMBER_ALIAS" minOccurs="0"/>
           <xsd:element name="CHILDREN_CARDINALITY" type="xsd:unsignedInt" 
            sql:field="CHILDREN_CARDINALITY"/>
           <xsd:element name="PARENT_LEVEL" type="xsd:unsignedInt" 
            sql:field="PARENT_LEVEL"/>
           <xsd:element name="PARENT_UNIQUE_NAME" type="xsd:string" 
            sql:field="PARENT_UNIQUE_NAME"/>
           <xsd:element name="PARENT_COUNT" type="xsd:unsignedInt" 
            sql:field="PARENT_COUNT"/>
           <xsd:element name="DESCRIPTION" type="xsd:string" 
            sql:field="DESCRIPTION" minOccurs="0" />
          </xsd:sequence>
         </xsd:complexType>
       </xsd:schema>
       <row>
        <CATALOG_NAME>Sample</CATALOG_NAME>
        <CUBE_NAME>Sample.Basic</CUBE_NAME>
        <DIMENSION_UNIQUE_NAME>[Year]</DIMENSION_UNIQUE_NAME>
        <HIERARCHY_UNIQUE_NAME>[Year]</HIERARCHY_UNIQUE_NAME>
        <LEVEL_UNIQUE_NAME>[Year].Levels(2)</LEVEL_UNIQUE_NAME>
        <LEVEL_NUMBER>2</LEVEL_NUMBER>
        <GENERATION_NUMBER>1</GENERATION_NUMBER>
        <MEMBER_ORDINAL>1</MEMBER_ORDINAL>
        <MEMBER_NAME>Jan</MEMBER_NAME>
        <MEMBER_UNIQUE_NAME>[Jan]</MEMBER_UNIQUE_NAME>
        <MEMBER_TYPE>1</MEMBER_TYPE>
        <MEMBER_CAPTION>Jan</MEMBER_CAPTION>
        <CHILDREN_CARDINALITY>0</CHILDREN_CARDINALITY>
        <PARENT_LEVEL>1</PARENT_LEVEL>
        <PARENT_UNIQUE_NAME>[Qtr1]</PARENT_UNIQUE_NAME>
        <PARENT_COUNT>1</PARENT_COUNT>
       </row>
       < ................More Rows............. >
      </root>
     </m:return>
    </m:DiscoverResponse>
   </SOAP-ENV:Body>
 </SOAP-ENV:Envelope>