Hi,
Hope someone can come up with an answer to this problem.
I'm running a report in BO which times out. The universe limits are 10 minutes and 50,000 rows and the report has two prompts, one for "begin week" and the other, "end week".
When I copy the SQL and paste it into a query tool and run it, the query always comes back with results (349 rows) in approx 5-8 minutes. The only change to the SQL is that I have to remove the @variable syntax and enter the specific week numbers that I want to query on.
Why does BO not return results? What is the overhead that BO is adding to the query process? How can I get round this problem?
Thanks.
Hope someone can come up with an answer to this problem.
I'm running a report in BO which times out. The universe limits are 10 minutes and 50,000 rows and the report has two prompts, one for "begin week" and the other, "end week".
When I copy the SQL and paste it into a query tool and run it, the query always comes back with results (349 rows) in approx 5-8 minutes. The only change to the SQL is that I have to remove the @variable syntax and enter the specific week numbers that I want to query on.
Why does BO not return results? What is the overhead that BO is adding to the query process? How can I get round this problem?
Thanks.