incorrect data in the report

[Former Member]

Hi Gurus,

I am runninf Profir Loss financial statement and Comparison query where the data is incorrect against the source.

Since the cube i m using here is 0fi_gl_c10, 0fi_gl_v10. I have used heirarchy fir financial statements.

Please help and suggest.

Thank You

[Former Member · Accepted solution]

Hi,

Check the BW report data and source table data, where exactly the data is not matching.

Also for FI data there are some standard programmes in ECC side where you can check the data is getting populated correctly and then compare BW report with that data.

Try to do end to end comparison of data  from source table to BW.

Regards,

Chandra Sekhar.

[Former Member · Accepted solution]

Hi Chandra,

As i mentioned above, the user is comparing my report with the same Standard ECC report.

How you want me to do analysis, since there is also a hierarchy created.

Thanks

Taniya

[Former Member]

Hi,Taniya

There are some steps maybe help you

1,using tcode RSRT to clear cache files and choose the constrict KF selection when running.

2,check the filter for the KF

3,validate RSRT query data with the list cube  for selection parameter..

Regards,

Leno

[Former Member]

Hello Leno,

Could you explain the above steps bit more.

Thanks

Taniya

[former_member182343]

HI,

Missmatch means..

-  Check for any filters at global level or at RKF/Selection level.

-  Conditions.

- Validate your query RSRT data with LISTCUBE for one Cutomer/Vendor and do analysis accordingly.

Regards,

Vijay

[Former Member]

Hi,

I meant to tell the data what i am seeing in the report is much difference against source system data.

As i mentioned above I am using a heirarchy for financial statement for the same the nodes balance sheet total value is not accurate.

Thanks

[former_member182343]

Hi,

Validate hierarchy data node wise at Infocube wise. May be issue is with Hierarchy or incorrect data at Infocube level.

If your report values and info cube values are matching and you have to further go to conclusion that issue is with loading.

[Former Member]

Hi Taniya,

You can follow these to resolve the problem:

1. Just check with functional guys if there any standard report available in source system for the same purpose. If it is available and its producing the correct result, check whether your BW report logic is same as this report.

2. Check your data at cube level applying same logic as confirmed by users and see if it produces correct result. If it does may be report logic have some problem.

3. Check if without using hierarchy your report produces correct reults. If it does there might be some problem with hierarchy. If it produces incorrect results may be report logic need to be changed.

Regards:

Jitendra

[Former Member]

HI vijay,

Here the report is fetching data form Virtual Cube which itself connected to physical cube.

0figl_v10 and 0figl_c10 and also 0figl_o10.

Can you please explain how to validate in this scenario and RKF

Thanks

[Former Member]

Hi Jitendra,

Thanks

1. Comparison between bi report and functional was done and on that circumstances only, The user raised an Issue incorrect.

2.As far as checking data is concerned the current report which i am talking about is created on Virtual cube (v10). Hence it gets data from C10 also from source directly at run time.

Note the report i used is Standard report on Finance GL

3. I have tried your option as well the data is not same as it was, but i wonder few figures are matching but rest is incorrect.

Thanks