WEBI calls query multiple times

[Former Member]

Hello,

I have BW 701 patch 11 ,

BOBJ sp4 patch 3.

on my production server.

When i run a PA query on WEBI layer, it calls the query multiple times. ( i can see from SM50 ) .

Normally query runs for 250 secs. Well, after 250secs, it finishes and starts again from the beginning, then starts again. This continues for 3-4 times.

That means, on WEBI it takes 3x slower than BEX Analyzer layer.

Why can this happen ?

[former_member188911]

there may be delegated measures that require the query to be triggered multiple times

, please check how the query is structured

thanks

Simone

[Former Member]

what do you mean by delegated measures ? i have calculated and restricted key figures on BEX Query ? for key figures, calculation and aggregation options are at default value.