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