0FIAR_C02_Q0001 Accounts Receivable report getting double values in report

[Former Member]

In FI the report 0FIAR_C02_Q0001 Accounts Receivable: DSO Analysis, Current Period  is showing the values exactly double to the values we are getting when compared to ECC side report values based on some selection criteria. This report is generating on the infocube 0FIAR_C02 and the data sources 0FI_AR_1 and 0FIAR_O06.

the values in BI report for 'Current Balance and 'Sales in Previous Period keyfigures are getting exactly double 264720 rather than 132360 .

Please resolve my issue.

thanks,

sapsdnhelp

[esjewett]

Since this is a question about BW, it belongs in the BW space and not the Data Warehousing space. I've moved the thread, but please use the BW space for these types of questions in the future.

Regards,

Ethan

(moderator)

[Former Member]

Hi

0FIAR_O06 is filled from 0FI_AR_6. 0FI_AR_6 replaces 0FI_AR_1 following the SAP documentation.

You should delete everything that originates from 0FI_AR_1 and that will remove your doubles.

[Former Member]

Hi,

In your infocube or at the query level by giving the same selections check if you have two similar requests. You can drilldown on the request ID with other selection and check if same request got loaded twice.

You can simply delete one of the request. Before deletion make sure that they are identical.

Regards,

Durgesh.

[mr_v]

Looks like duplicate data loads.. Delete old request from the cube and execute the report

[andrea_previati]

check if you have loaded two times the same data - your data loads are in FULL or in DELTA ?