How to display a Logo in WEbi reports
How to troubleshoot a Query which is slow in Business objects where as the same query is running fast in Oracle?
Can any one tell me answer for 2nd questions.
It will be helpfull.
Thanks
Regards
shravya
sravya (BOB member since 2006-05-26)
I’ll avoid questioning the reason for your post, but the quickest reply would be to use the BO trace feature.
In all fairness you can only answer that question by starting with some questions of your own to narrow it down, so if BO trace is not what they’re looking for then:
Which product and version i.e desktop, zabo or webi / v5 - v6 - XI ?
By slow - is this based on results returned or query runtimes?
i.e. Results returned would probably be a memory issue.
The universe design can be ignored - assuming the same generated sql is used so the order of tables in the where clause etc should be the same.
Zabo and webi will be queuing for connections as well as being impacted by server loads and activity, admin settings, network bandwidth, caching etc.
The universe connection should be examined in all instances and you need to ask the DBA id the BO connection id has been restricted in any way.
and so forth …
MikeD 
(BOB member since 2002-06-18)
sravya,
Did you read through this topic before posting your question?
MichaelWelter 
(BOB member since 2002-08-08)