Can OBIEE run an XML Publisher data template and receive an XML file?

Question

I need to generate a report in OBIEE where the data is generated by an EBS data template (Release 12). The XLAAPRPT data template is core.

The output of the data template is XML.

OBIEE needs to receive this XML and generate the output for the user.

Thank you for your help.

Helder.Amaral · Answer

Hello Gianni.

The visualization will be through OBIEE, users prefer to visualize through OBIEE for the flexibility of manipulation and export to other tools, for example Excel.

Just remembering that XML Publisher is in the EBS database which is different from the OBIEE database (BI Server).

I will analyze this possibility with RPD.

Thank you very much.

Gianni Ceresa · Answer

And what is OBIEE supposed to do with your XML?

If you have a Publisher data model, why don't you just create a report on top in Publisher directly?

Publisher can use the BI Server as a data source because it can be accessed "as a database", the other way round not much: OBIEE use the RPD, BI Publisher isn't a physical database source in the RPD.