Data mismatch between dashboard and bw report

[former_member221192]

Hi expert,

Data is mismatchin between dashboard and BW report of .I am using SAP BW connection ,

Dashboard screen shot

BW Query output

What is the issue can you please suggest...

[former_member182541 · Accepted solution]

Try to run the bex query without any filters in bex as well in the dashboard. If the data is big then apply the filter in the query designer itself not in the selection parameter and check whether it brings the entire data what you see in the bex output, then try to drill down by step by step filter.

If you have written and any CMOD exits in the BW, then you need to check whether it works. Because sometimes it won't work as what you have in bex. Please check the above steps and let us know the outcome to help further.

[Former Member]

Hi Ganapathy,

Check whether you are using any variables using RSRT and same values are you passing when you are comparing the data output in Dashboard using BW connection and in RSRT.

Regards,

Venkat

[arvind_shukla4]

Hi Ganapathy,

Please check the Prompt filter and Variables which you are passing to get the output in Dashboard and BW.

It seems that some filters are missing in dashboard.

Thanks

Arvind Shukla