MDSCHEMA_MEASURES Rowset

MEASURES rowsetは使用できるメジャーに関する情報を含んでいます。

GUID: MDSCHEMA_MEASURES

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

表 37. MDSCHEMA_MEASURES rowset構造体

列名

Essbaseマッピング

CATALOG_NAME

アプリケーション名

CUBE_NAME

データベース名

MEASURE_NAME

会計次元メンバー名

MEASURE_UNIQUE_NAME

前述のメンバー名

MEASURE_CAPTION

前述のメンバー名

MEASURE_AGGREGATOR

Essbase ADDITION: 1

Essbase SUBSTRACTION: 17

Essbase MULTIPLICATION: 18

Essbase DIVISION: 19

Essbase PERCENT: 20

Essbase NOOP: 21

DESCRIPTION

メンバーのコメント

DATA_TYPE

5

EXPRESSION

メンバー式

MEASURE_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_MEASURES</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="MEASURE_NAME" type="xsd:string"  
         sql:field="MEASURE_NAME"/>
        <xsd:element name="MEASURE_UNIQUE_NAME" type="xsd:string" 
         sql:field="MEASURE_UNIQUE_NAME"/>
        <xsd:element name="MEASURE_CAPTION" type="xsd:string" 
         sql:field="MEASURE_CAPTION"/>
        <xsd:element name="MEASURE_AGGREGATOR" type="xsd:int" 
         sql:field="MEASURE_AGGREGATOR"/>
        <xsd:element name="DESCRIPTION" type="xsd:string" 
         sql:field="DESCRIPTION" minOccurs="0"/>
        <xsd:element name="DATA_TYPE" type="xsd:unsignedShort" 
         sql:field="DATA_TYPE"/>
        <xsd:element name="NUMERIC_PRECISION" type="xsd:unsignedShort" 
         sql:field="NUMERIC_PRECISION"/>
        <xsd:element name="NUMERIC_SCALE" type="xsd:short" 
         sql:field="NUMERIC_SCALE"/>
        <xsd:element name="EXPRESSION" type="xsd:string" 
         sql:field="EXPRESSION" minOccurs="0"/>
        <xsd:element name="MEASURE_IS_VISIBLE" type="xsd:boolean" 
         sql:field="MEASURE_IS_VISIBLE"/>
       </xsd:sequence>
      </xsd:complexType>
     </xsd:schema>
     <row>
      <CATALOG_NAME>Sample</CATALOG_NAME>
      <CUBE_NAME>Sample.Basic</CUBE_NAME>
      <MEASURE_NAME>Measures</MEASURE_NAME>
      <MEASURE_UNIQUE_NAME>[Measures]</MEASURE_UNIQUE_NAME>
      <MEASURE_CAPTION>Measures</MEASURE_CAPTION>
      <MEASURE_AGGREGATOR>0</MEASURE_AGGREGATOR>
      <DATA_TYPE>5</DATA_TYPE>
      <NUMERIC_PRECISION>0</NUMERIC_PRECISION>
      <NUMERIC_SCALE>0</NUMERIC_SCALE>
      <MEASURE_IS_VISIBLE>true</MEASURE_IS_VISIBLE>
     </row>
     < ................More Rows............. >
    </root>
   </m:return>
  </m:DiscoverResponse>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>