Skip to Content

Why generating SQL script takes a long time?

May 10, 2017 at 08:59 AM


avatar image
Former Member


After migration from SAP XI 3.1 to SAP BI 4.1 we noticed an problem.

The universe and Web Intelligence reports take a much longer time to generate the SQL script. Due to this:

  1. Significant amount of the time when refreshing a report is spent on SQL generation not on query refresh.
  2. Prompt list of values takes a long time to populate
  3. In UDT, edit list of values takes a long time

.unv universe is based on Teradata DB.

Thanks in advance.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers