Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

XML Output using BIPublisher

Received Response
1
Views
5
Comments
SYedurur
SYedurur Rank 1 - Community Starter
edited Aug 13, 2024 6:12PM in Oracle Analytics Cloud and Server

Hi Experts,

My client needs  XML output in oracle table.Can you help me which option is best to achieve this XML output.

Answers

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    What do you mean by "XML output in oracle table"?

  • SYedurur
    SYedurur Rank 1 - Community Starter

    Hi,

    Source data is  Oracle table.My  Client wants the output as a XML file  in their standard format.When i try to use the BIpublisher to generate xml it is giving me XML output but in a different format.I want to generate the XML in the format the client wants.

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    If I understand you correctly, you have a data model which gives you default XML and you need to give your customer an XML of another format. Right?

    You need to create a report with an XSLT template to transform generated XML into the desired form. Data model itself is not a report, but only a half of it.

  • SYedurur
    SYedurur Rank 1 - Community Starter

    Thanks Andrew.I will work on XSLT templates.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Oracle database itself can dump a table to xml ... using BIP or OBIEE to do this is inefficient.  Take a look at using the Oracle DB Documentation:  https://docs.oracle.com/cd/E11882_01/appdev.112/e23094/xdb13gen.htm#ADXDB1600