Does anyone have any suggestions to help me fix this issue?

Donna Fazio

Summary: Dashboard performance issue

Content (required):Pivots populate within seconds within the analyses report. However, running through the dashboard it can take up to 20 minutes or time out. If it times out and i hit refresh it will eventually populate. I suspect it might have something to do with the permissions set within the prompt. But honestly am not sure. The dashboard is meant for Sales Managers and upper management to inspect sales territory health. So we've set up information within the prompt to prevent them from seeing data that does not apply to them... ANY SUGGESTIONS WOULD BE GREATLY APPRECIATED!!

Version (include the version you are using, if applicable): Oracle Business Intelligence 11.1.1.9

Code Snippet (add any code snippets that support your topic, if applicable):

Nathan CCC

Hi, so you have a "good" and "bad" test case. So lets compare them. Get your user to go to the dashboard page. Or do it yourself if you can replicate the problem with your sign in. Then at the same time you go to "manage sessions" /analytics/saw.dll?Sessions, find their session, view log. This may help you understand what is going on. Look at the timestamps and the numbers of rows returned. For example, did it get data from the physical database server fast but then spend loads of time in the middleware doing post query things? Or if the problem is in the physical query? If so cut paste that in to a new data model, comment in and out stuff, work out what is taking the time? Compare all this to the log from you running it the "fast" way - maybe by executing the logical sql in page "issue sql" /analytics/saw.dll?issuerawsql to get the log for that. Good luck hunting!