Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
OBIEE Web services

651113
Member Posts: 17
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=""Periods"."Month"" 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=""Sales Measures". "Dollars"" 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=""Share Measures"."Share of Year Dollars"" 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?
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=""Periods"."Month"" 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=""Sales Measures". "Dollars"" 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=""Share Measures"."Share of Year Dollars"" 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.