Forum Stats

  • 3,782,963 Users
  • 2,254,716 Discussions
  • 7,880,231 Comments

Discussions

OBIEE Web services

Hello,
When we use Oracle BI Web services, the output is in a certain format, which is given below.

<rowset xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" ><xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:saw-sql="urn:saw-sql" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset"><xsd:complexType name="Row"><xsd:sequence><xsd:element name="Column0" type="xsd:date" minOccurs="0" maxOccurs="1" saw-sql:type="date" saw- sql:displayFormula="&quot;Periods&quot;.&quot;Month&quot;" saw-sql:aggregationRule="none" saw-sql: aggregationType="nonAgg" saw-sql:tableHeading="Periods" saw-sql:columnHeading="Month" /><xsd:element name="Column1" type="xsd:double" minOccurs="0" maxOccurs="1" saw-sql:type="double" saw-sql:displayFormula="&quot;Sales Measures&quot;. &quot;Dollars&quot;" saw-sql:aggregationRule="sum" saw-sql:aggregationType="agg" saw-sql:tableHeading="Sales Measures" saw-sql:columnHeading="Dollars" /><xsd:element name="Column2" type="xsd:double" minOccurs="0" maxOccurs="1" saw-sql: type="double" saw-sql:displayFormula="&quot;Share Measures&quot;.&quot;Share of Year Dollars&quot;" saw-sql: aggregationRule="complex" saw-sql:aggregationType="agg" saw-sql:tableHeading="Share Measures" saw-sql: columnHeading="Share of Year Dollars" /></xsd:sequence></xsd:complexType></xsd:schema><Row><Column0>2000-04-01</ Column0><Column1>639202.0</Column1><Column2>11.2355892856546</Column2></Row><Row><Column0>2000-05-01</ Column0><Column1>627225.0</Column1><Column2>11.0250632659077</Column2>

<SNIP>

</ Column0><Column1>416159.0</Column1><Column2>36.0457502187037</Column2></Row></rowset>


Is it possible to change the format in which the data appears?
Tagged:
This discussion has been closed.