MDSCHEMA_LEVELS Rowset

The LEVELS rowset contains information about the levels available in a dimension.

GUID: MDSCHEMA_LEVELS

Table 11 describes the rowset structure.

Table 11. MDSCHEMA_LEVELS Rowset Structure

Column Name	Essbase Mapping
CATALOG_NAME	Application name
CUBE_NAME	Database name
DIMENSION_UNIQUE_NAME	Name of the dimension to which the level belongs
HIERARCHY_UNIQUE_NAME	Name of the dimension to which the level belongs
LEVEL_NAME	Unique level name
LEVEL_UNIQUE_NAME	Unique level name
LEVEL_CAPTION	Level name
LEVEL_NUMBER	Level number
LEVEL_CARDINALITY	Number of members in the level
LEVEL_TYPE	MDLEVEL_TYPE_ALL (for dimension level) MDLEVEL_TYPE_TIME (for dimension type TIME) MDLEVEL_TYPE_REGULAR (for all others)
LEVEL_UNIQUE_SETTINGS	2 (MDDIMENSIONS_MEMBER_NAME_UNIQUE)
LEVEL_IS_VISIBLE	True
ESSBASE_GEN_UNIQUE_NAME	Generation unique name
ESSBASE_GEN_CAPTION	Generation caption

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

<?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_NAME" type="xsd:string" 
         sql:field="LEVEL_NAME"/>
        <xsd:element name="LEVEL_UNIQUE_NAME" type="xsd:string" 
         sql:field="LEVEL_UNIQUE_NAME"/>
        <xsd:element name="LEVEL_CAPTION" type="xsd:string" 
         sql:field="LEVEL_CAPTION"/>
        <xsd:element name="LEVEL_NUMBER" type="xsd:unsignedInt" 
         sql:field="LEVEL_NUMBER"/>
        <xsd:element name="LEVEL_CARDINALITY" type="xsd:unsignedInt" 
         sql:field="LEVEL_CARDINALITY"/>
        <xsd:element name="LEVEL_TYPE" type="xsd:int" 
         sql:field="LEVEL_TYPE"/>
        <xsd:element name="LEVEL_UNIQUE_SETTINGS" type="xsd:int" 
         sql:field="LEVEL_UNIQUE_SETTINGS"/>
        <xsd:element name="LEVEL_IS_VISIBLE" type="xsd:boolean" 
         sql:field="LEVEL_IS_VISIBLE"/>
        <xsd:element name="DESCRIPTION" type="xsd:string" 
         sql:field="DESCRIPTION" minOccurs="0"/>
			 <xsd:element name="ESSBASE_GEN_UNIQUE_NAME" type="xsd:string" 
				 sql:field="ESSBASE_GEN_UNIQUE_NAME"/>
			 <xsd:element name="ESSBASE_GEN_CAPTION" type="xsd:string" 
				 sql:field="ESSBASE_GEN_CAPTION"/>
       </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_NAME>[Year].Levels(2)</LEVEL_NAME>
      <LEVEL_UNIQUE_NAME>[Year].Levels(2)</LEVEL_UNIQUE_NAME>
      <LEVEL_CAPTION>[Year].Level 2</LEVEL_CAPTION>
      <LEVEL_NUMBER>2</LEVEL_NUMBER>
      <LEVEL_CARDINALITY>12</LEVEL_CARDINALITY>
      <LEVEL_TYPE>4</LEVEL_TYPE>
      <LEVEL_UNIQUE_SETTINGS>2</LEVEL_UNIQUE_SETTINGS>
      <LEVEL_IS_VISIBLE>true</LEVEL_IS_VISIBLE>
			<ESSBASE_GEN_UNIQUE_NAME>[Year].[Months]</ESSBASE_GEN_UNIQUE_NAME>
			<ESSBASE_GEN_CAPTION>[Year].Months</ESSBASE_GEN_CAPTION>
     </row>
     < ................More Rows............. >
    </root>
   </m:return>
  </m:DiscoverResponse>
 </SOAP-ENV:Body>
</SOAP-ENV:Envelope>