DISCOVER_ENUMERATORS Rowset

GUID: DISCOVER_ENUMERATORS

Table 45 describes the rowset structure.

Table 45. DISCOVER_ENUMERATORS Rowset Structure

Column Name	Essbase Mapping
EnumName	Name of the enumerator that contains a set of values
EnumDescription	Description of the enumerator
ElementName	Name of one of the value elements in the enumerator set Example: TDP
ElementDescription	Description of the element
EnumType	Data type of the Enum values
ElementValue	Value of the element Example: 01

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">
 <SOAP-ENV:Body>
  <Discover xmlns="urn:schemas-microsoft-com:xml-analysis"
   SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <RequestType>DISCOVER_ENUMERATORS</RequestType>
  <Restrictions>
   <RestrictionList></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

<?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="EnumName" type="xsd:string" 
         sql:field="EnumName"/>
        <xsd:element name="EnumDescription" type="xsd:string"
         sql:field="EnumDescription" minOccurs="0"/>
        <xsd:element name="ElementName" type="xsd:string" 
         sql:field="ElementName"/>
        <xsd:element name="ElementDescription" type="xsd:string" 
         sql:field="ElementDescription" minOccurs="0"/>
        <xsd:element name="ElementValue" type="xsd:string" 
         sql:field="ElementValue" minOccurs="0"/>
        <xsd:element name="EnumType" type="xsd:string" 
         sql:field="EnumType"/>
       </xsd:sequence>
      </xsd:complexType>
     </xsd:schema>
     <row>
      <EnumName>ProviderType</EnumName>
      <ElementName>TDP</ElementName>
      <EnumType>string</EnumType>
     </row>
     < ................More Rows............. >
    </root>
   </m:return>
  </m:DiscoverResponse>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>