MDSCHEMA_MEMBERS Rowset

The MEMBERS rowset contains information about the available members.

GUID: MDSCHEMA_MEMBERS

Table 38 describes the rowset structure.

Table 38. MDSCHEMA_MEMBERS Rowset Structure

Column Name	Essbase Mapping
CATALOG_NAME	Application name
CUBE_NAME	Database name
DIMENSION_UNIQUE_NAME	Dimension name
HIERARCHY_UNIQUE_NAME	Dimension name
LEVEL_UNIQUE_NAME	Level name
LEVEL_NUMBER	Level number
GENERATION_NUMBER	Generation number
MEMBER_ORDINAL	Member number
MEMBER_NAME	Member name
MEMBER_UNIQUE_NAME	Unique member name
MEMBER_TYPE	1 (REGULAR)
MEMBER_CAPTION	Member name
MEMBER_ALIAS	Default alias
CHILDREN_CARDINALITY	Child count
PARENT_LEVEL	Level number of the parent. For dimension, same level number as the dimension level number
PARENT_UNIQUE_NAME	Name of the parent. For dimension, same name as the dimension name
PARENT_COUNT	Always 1
DESCRIPTION	Member comment

Request Example

<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>

Response Example(truncated)

<?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>