Skip to Content
0

Why generating SQL script takes a long time?

May 10, 2017 at 08:59 AM

14

avatar image
Former Member

Hi!

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.

BR,
Jana

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

0 Answers