where would you check performance of webi? query is taking long time to run

[Former Member]

Hello All,

In the bex query world running on portal you were able to go to sm50 and check what the query is doing and where it is taking a long time or atleast you were able to see the processes runing.

Where would you check the running processes when you are running a webi query, we are trying to write a webi report which is on universe which is created on bex query. The report is very simple just two fields and an mandatory variable which is coming from bex query (have defined the variable in bex query). When we exeute the query it is taking a long time just spinning and I am not getting any data back, on the same query before even hitting the run query button, I am trying to put a object in query filters and set the filter as In list from Value(s) from list and it is taking forever to set that filter.

Can we go to CMC or BW backend and check anywhere we are using sap authentication, I see the number of sessions in CMC but that is it.

Thanks for help in advance.

[arijit_das · Accepted solution]

did you try executing the mdx generated by webi in mdxtest transaction ? how long did it take?

[Former Member]

Hi,

1.First, you would need to check query performance from BW.

2. Once it is working fine, you should probably check the query performance from BO.

3. Check out possible connection parameters options such as array fetch size in the available universe connection. This could probably improves query performance.

4. Check if you can do anything from BW, which could improve performance.

Regards

Gowtham

[Former Member]

Thank you both for the replies.

How would I get the MDX that is generated by the query, I remember there is a note for starting the MDX logging. Can you please let em know how would I get the MDX statement. Thanks.

Gowtham - What is the optimal array fetch size that needs to set for the universes, can you explain bit more about array fetch size?

All our universes are on BEx queries designed in SAP BW in that case does the array fetch size matter and array bind size matter? I had read this in oneof the universe designer manuals for OLAP universes The Array fetch size, Array bind size, and Login timeout parameters are not used for OLAP connections

Thanks again for replies.

[Former Member]

Hi Cathy,

Regarding the query, we cannot retrieve from BO or WEBI.

We should check this from BW / BEX.

Regarding array fetch size parameters, I am not sure whether these options available for SAP BW connections or not. Please check. I have never looked at this option when I worked with SAP. But verified during not sap data.

As of now, I don't have access to Universes with SAP connections. So I couldn't verify this. If the parameters available, you could probably use this.

[arijit_das]

This article will let u know the details of MDX logging process:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90b02218-d909-2e10-1988-a2ca74547...