BusinessObjects Board

webi Report taking time to refresh (xi3.1)

building semantic layer
#1

Hi all,

We have a BO xi 3.1 SP7 setup. we have linked universe. we have a webi report connecting to the universe. when query generated from this report executed in sql client, it completes in 8-9 min and retrun data as well. However when same query is refreshed through webi report, it runs till the timeout limit set (30 min) at universe level and do not return any data.

Any idea why the issue in query when run from report?

any parameter to be set/check at universe/report level?

Regards,
Sameer

sam1507 (BOB member since 2011-09-20)

#2

Have you run the exact SQL generated by the Webi query as the SQL in the SQL client and fetched all results rather than simply the first page of results?

#3

Hi, I did run the full query and extracted full result and not just the first page.

sam1507 (BOB member since 2011-09-20)

#4

What’s the array fetch size set at? I typically change it to 1000 and see how it goes.

#5

its set at default value 250. I will change the value to 1000 and will let you know if it works.

sam1507 (BOB member since 2011-09-20)

#6

See also Why is my report so slow, an oldie but goldie 8)

and also here: diff between Select SUM (Table. Field) & Select Table. F

Andreas :de: (BOB member since 2002-06-20)