« September 27, 2007 | Main | October 2, 2007 »

October 1, 2007 Archives

October 1, 2007

Multi Answer Reports

No, BIP has not become the ulltimate Oracle able to answer multiple questions - those of you using the BIEE/BIP integration will hopefully have noticed and read about the ability to pull an Answer, a BIEE report object if you will, into BIP as a datasource that you can now format using a publisher template.


What you may not have noticed is that you can pull multiple Answers into a single BIP report and create a template over the top of the combined data set. To achieve it we take advantage of the Concatenate Datasource functionality. All we need do it create multiple Answer based data sources:


Answers1:


then use the UI at the Data  Model level of the report tree and select 'Concatenated SQL Data Source'


Answers2:


 ... before you point out a problem. It's not one,  just an oversight on our part - I know you do not have SQL datasources but ignore that, we will concatenate your Answers into a single XML source.


Answers3:


another Easter Egg if you will.

About October 2007

This page contains all entries posted to Oracle BI Publisher Blog in October 2007. They are listed from oldest to newest.

September 27, 2007 is the previous archive.

October 2, 2007 is the next archive.

Many more can be found on the main index page or by looking through the archives.

Powered by
Movable Type and Oracle