BEx performance issues, multiple plants

[Former Member]

Hello,

I am having an issue where when I run an inventory report that includes more than one plant, the report is slowed down exponentially.  Individually running each plant will take approximately a minute and a half.  When I enter more than one plant into the variables screen it will take up to an hour to run.  Just looking for some insight as to why having multiple entries would cause this issue.

Thanks in advance.

-James

[sander_vanwilligen · Accepted solution]

Hi James,

Please review SAP Note 419490 - Non-cumulatives: poor query performance for 5 performance tips.

Best regards,

Sander

[Former Member · Accepted solution]

Thank-you Sander, a helpful note.

[sapna_jgurudutt · Accepted solution]

Hi,

Can you please refer the following SAP Note and check whether it helps you:
1681396 - Query Performance

And, are you using replacement path variable with regard to the query
when executing this query in web side where the problem mentioned here is occurring?

If replacement path variable is used, can you please refer
the following SAP Note and check whether it helps you:
1751318 - Performance: variables filled by pre-query in Java Web

Thanks & Regards,

Sapna