Hi,
I have Webi Report it take about 7 minute to run,
i am using Webi XI r 2 version,
Rport have 2 Query ,
query 1 has 1 filter on query level,
report 2 has 3 filters.
report is created with merge dimension,
here is the thing i try every thing , database level take 1 minute , but report level 7 minute,
but when i run seperate query query 1 run good , but query 2 take long time , can any one help me with this ,
thanks in Advance
NidaKhan (BOB member since 2012-08-21)
Report performance is a very broad topic. I would take assistance from DBA to tune the query if possible… Also look at this thread.
https://bobj-board.org/t/15226/29
BO_Chief 
(BOB member since 2004-06-06)
It relates to how many result records retrieved from your query.
If you have lots of records, it needs time to organize the data when you do update in report level
summoner 
(BOB member since 2008-12-18)
Hi ,
You can try this for anlysis :
Go to Edit query and run Query 1 only and see how much time BO takes … Do the same for second query too .
If both the query takes small time but when run together takes more time then problem is with Merging … Remove Unwanted dimensions from Merge …
If Second query is taking more time then you can go for Database tuning by Looking at PLan for Query
Regards
Sapan
swapnil_taz 
(BOB member since 2006-04-06)
Please post the SQL statements that the two queries are generating as well as how many rows they typically return.