cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with Hirerachies

Former Member
0 Kudos

Hi Experts,

I am facing problem regarding the execution time of dashboards. I have a couple of queries in my dashboard. The execution time of this dashboard is high. One of the query has hierarchies, i guess the problem might be due to this query.

Can anyone please suggest me if there are any OSS notes available for this kind of scenario or suggestions for improving the execution time of the dashboard.

Thanks in Advance,

KR

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

A couple of quick and easy things to check...

First, make sure that you are not opening the hierarchy at too low a level initially. The higher up you can start in the hierarchy, the faster the query will run. Of course, some extra time will be required for the user subsequently to open levels in the hierarchy, so it is a trade-off.

Second, check the query settings in RSRT to make sure the Read Mode of your query is NOT set to "A Query to Read All Data At Once". Either of the other two options available ("X Query to Read Data During Navigation", or "X Query to Read When You Navigate or Expand Hierarchies") will give much better performance.

Hope this helps...

Bob