Location: Oracle BI Publisher

Discussion: Bursting using multiple data modelsReported This is a featured thread

Showing 2 posts

Anupam1412
Bursting using multiple data models
Apr 27 2009, 3:40 AM EDT | Post edited: Apr 27 2009, 3:40 AM EDT
Has anyone tried bursting using multiple data models? Please let me know, it's urgent Do you find this valuable?    
Keyword tags: None

Klaus.Fabian
1. RE: Bursting using multiple data models
Jun 3 2009, 1:21 PM EDT | Post edited: Jun 3 2009, 1:21 PM EDT
To run reports - or burst from multiple data sources you need to combine the data first with a data template.
A data template allows you to combine multiple queries in a hiearchical way - i.e. master detail.

For the bursting to work all the data that should be in one report instance hast to be in one subtree of the
XML data. I.e. each report needs to be under /ROWSET/ROW. You can also combine multiple subsequent
rows like all /DATA/INVOICE into a single report. Check the user guide for data template and bursting.

By the way bursting is different in the deployments for Oracle E-Busines Suite, Peoplesoft and the standalone
BI Publisher enterprise. So it is important to state the context.

Sorry for the late reply, I didn't see it earier.

Klaus
Do you find this valuable?