Skip to Content
0
Former Member
Jun 26, 2009 at 04:45 AM

Frontend Query display in Analyzer taking more time

11 Views

Hi ,

We have severe performance issue with one of Query .

We are using several Hierarchy nodes in query , we have lot of customer exits and query is built on virtual Provider. All these performance issues cannot be ruled out as user is insisting to have them . I tried all suggestions posted in SDN before i am posting this message.

My query is executing fine in RSRT it takes approximately 2 minutes to execute in RSRT , However when i try to execute the same query in Analyzer it takes more than 20 min and work book built on the same query is still worst , It takes 1 hours to display the result.

Kindly suggest me to over come this issue.

Thanks in Advance

Anil