Hi,
Iam using BO 5.1.7 with DB2.One of my report uses the combined queries of 8 combinations and uses around 15 objects .This report takes very long time to display based on the number prompts.
Could anybody suggest some tips on how to optmize the speed of the report.
Thanks,
Vikram
vikramcts1 (BOB member since 2005-07-26)
From what you’re telling me, the query isn’t taking that long to run, but the report takes a long time computing the results. Is that correct? If so, I would suggest moving your combined queries into a Derived table in the universe, and create objects from that for your report. Then the database will handle the complexity, and the results should render faster on the report.
MichaelWelter 
(BOB member since 2002-08-08)
Hi,
The Derived table feature is not supported by the Bo 5.1.7.Actually, the report takes a long time to display the results due to the 8 combinations of the Union.Could you please suggest some other alternative.
Thanks,
Vikram
vikramcts1 (BOB member since 2005-07-26)
Oops, I missed that. 
The alternative is to have a DBA create a view in the database, and then add it as a table to your universe.
MichaelWelter (BOB member since 2002-08-08)
(BOB member since 2002-06-20)