webi report created on olap universe, execution taking more time ,while bexquery is executing in a fraction of sec ?

[Former Member]

What is the main cause of it ?

[former_member188911 · Accepted solution]

in simple words, because the WebI engine needs to flatten the cube and then do all the calculations

if you want a more complex explanation go here http://scn.sap.com/community/bi-platform/businessobjects-bi-for-sap/blog/2011/02/16/dear-abi--perfor...

thanks and regards

Simone

[Former Member · Accepted solution]

Thanks

my client is using xi 3.1 only

so help me in this regards

[former_member184594]

is right on this one. If you want your Bex query to run faster, it is better you use BICS connection for WebI so that your query is not flattened and accesses Bex directly which will result in better performance than OLAP universe. (You need to be BO 4.0 to use this type of connection. It is the best if you are on BO 4.0 SP4 or SP5.)

For more information check the link below:

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2012/07/19/bics-vs-bapi-vs-df-rel...

[Former Member]

Thanks Zahid n simone

but my client is using xi 3.1, in  this version only it should work properly help me in this .....

[former_member188911]

if you are on XI3.1 the link I provided earlier should point you to  the right direction.