XML : XML element read and stored in an array [duplicate]

This question already has an answer here:

Below given is the xml file in which I have to read the element inside <expression> tag(EG:-Branch.Country) and store it in the array.

  <queries>      <query name="Query1">          <source>              <model/>          </source>          <selection>              <dataItem name="Country" aggregate="none" rollupAggregate="none">                  <expression>[Sales (query)].[Branch].[Country]</expression>                  <XMLAttributes>                      <XMLAttribute name="RS_dataType" value="3" output="no"/>                      <XMLAttribute name="RS_dataUsage" value="attribute" output="no"/>                  </XMLAttributes>              </dataItem>              <dataItem name="Product line" aggregate="none" rollupAggregate="none">                  <expression>[Sales (query)].[Products].[Product line]</expression>                  <XMLAttributes>                      <XMLAttribute name="RS_dataType" value="3" output="no"/>                      <XMLAttribute name="RS_dataUsage" value="attribute" output="no"/>                  </XMLAttributes>              </dataItem>              <dataItem name="Quantity" aggregate="total">                  <expression>[Sales (query)].[Sales].[Quantity]</expression>                  <XMLAttributes>                      <XMLAttribute name="RS_dataType" value="1" output="no"/>                      <XMLAttribute name="RS_dataUsage" value="fact" output="no"/>                  </XMLAttributes>              </dataItem>              <dataItem name="Revenue" aggregate="total">                  <expression>[Sales (query)].[Sales].[Revenue]</expression>                  <XMLAttributes>                      <XMLAttribute name="RS_dataType" value="2" output="no"/>                      <XMLAttribute name="RS_dataUsage" value="fact" output="no"/>                  </XMLAttributes>              </dataItem>              <dataItemListSummary refDataItem="Quantity" aggregateMethod="total" name="Total(Quantity)"/>              <dataItemListSummary refDataItem="Revenue" aggregateMethod="total" name="Total(Revenue)"/>              <dataItemListSummary refDataItem="Quantity" aggregateMethod="total" name="Total(Quantity)2"/>              <dataItemListSummary refDataItem="Revenue" aggregateMethod="total" name="Total(Revenue)1"/>          </selection>      </query>  </queries>    

No comments:

Post a Comment