Bex Query results differ

[former_member217770]

Hi All,

when i test results between two bex queries . the expected results are coming correctly. Afetr moving them to production the results are not matching.

Again i tested the in quality and then correct in QA but wrong in production.

What could be the reason?

Thankyou

[Loed · Accepted solution]

Hi Naiduz,

Try to compare manually the queries in QA and PROD if they are really the same..

Regards,

Loed

[former_member217770 · Accepted solution]

it is because of restrictions between   QA and PRD Queries different . issue got resolved by changing the restrictions same as QA.

[sapna_jgurudutt]

Hi,

Is this problem occurring while trying to execute the query from the relevant BW Backend system ->

transaction RSRT -> entering relevant Query and clicking on button Execute ?

or

while executing the query from the java web side?

Thanks & Regards,

Sapna

[former_member186053]

Hi Naiduz,

Are you trying to run both reports with same selections, you may not have all the data similar to QA until unless if you are loading data to QA daily. Have you compared the data in infoproviders of underlying reports with same selections. As told by Swati you might have missed in your transports or may be the changes are not overwritten in Prod.

Thanks,

Vengal.

[swati_gawade]

Hi Naiduz,

Please check if the transports were captured correctly. check if any formula operand missing.

When you are testing in QA check for the same set of data for which production is in error. test for all scenario's. there is a possibility that you are missing any specific scenario to test in QA which is apearin in Production.

Also you may want to cross check the data in underlying nfo-provider if it matches or not with each other.

-Swati.