Skip to Content
avatar image
Former Member

Why generating SQL script takes a long time?


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.


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers