DISCOVER_PROPERTIES Rowset

GUID: DISCOVER_PROPERTIES

Table 14 describes the rowset structure.

Table 14. DISCOVER_PROPERTIES Rowset Structure

Column Name	Essbase Mapping
PropertyName	Name of the property
PropertyDescription	Description of the property
PropertyType	XML data type of the property.
PropertyAccessType	Access for the property. The value can be Read, Write, or ReadWrite
IsRequired	True if a property is required, false if it is not required
Value	Current value of the property

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_PROPERTIES</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="PropertyName" type="xsd:string"
         sql:field="PropertyName"/>
        <xsd:element name="PropertyDescription" type="xsd:string"
         sql:field="PropertyDescription"/>
        <xsd:element name="PropertyType" type="xsd:string" 
         sql:field="PropertyType"/>
        <xsd:element name="PropertyAccessType" type="xsd:string" 
         sql:field="PropertyAccessType"/>
        <xsd:element name="IsRequired" type="xsd:boolean" 
         sql:field="IsRequired"/>
        <xsd:element name="Value" type="xsd:string" 
         sql:field="Value"/>
       </xsd:sequence>
      </xsd:complexType>
     </xsd:schema>
     <row>
      <PropertyName>ProviderName</PropertyName>
      <PropertyDescription>The name of the Analytic Services Provider
      </PropertyDescription>
      <PropertyType>string</PropertyType>
      <PropertyAccessType>Read</PropertyAccessType>
      <IsRequired>false</IsRequired>
      <Value>Analytic Services XML for Analysis Provider</Value>
     </row>
     < ................More Rows............. >
    </root>
   </m:return>
  </m:DiscoverResponse>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>