BI Publisher (MOSC)

MOSC Banner

Multi query report

edited Aug 27, 2010 12:48AM in BI Publisher (MOSC) 1 commentAnswered ✓
 

I have a requirement where I have two queries giving two different outputs, I want these two in one single report with two layouts, I was able to achieve this with Concatenate option and there by build by RTF templates based on the Groups of each query, The problem I found is the performance because everytime view is hit by choosing the required report layout both the queries are running and ther by affecting performance, Is there anyway that when I choose the layout only the query related to that layout is run and other when I choose the other

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center