Load InfoProvider UI loading in double records

[Former Member]

Hey All,

Can anyone think of a reason why a Load_InfoProvider_UI would be loading in double records? I forced the load below to reject so I could get a list of the records, and I'm just trying to load in 1 transaction as a test (2 records due to Local Currency vs. USD). However, as you can see below, Record #1 shows up twice, as well as Record #2. This is causing doubled data, showing Sales at 11,393.52 in the system since the records are duplicated.

1 ,ACTUAL,000018,BW_COPA_IS,VALUE,01160PS1400038101272,0000001030,LC,2013.01,ZFAGROSSSALES,-5696.76

2 ,ACTUAL,000018,BW_COPA_IS,VALUE,01160PS1400038101272,0000001030,USD,2013.01,ZFAGROSSSALES,-5696.76

1 ,ACTUAL,000018,BW_COPA_IS,VALUE,01160PS1400038101272,0000001030,LC,2013.01,ZFAGROSSSALES,-5696.76

2 ,ACTUAL,000018,BW_COPA_IS,VALUE,01160PS1400038101272,0000001030,USD,2013.01,ZFAGROSSSALES,-5696.76

Listcube in BW showing the value should be 5,696.76 for each currency type:

Any ideas on what might be wrong and what is causing it to process the same record twice?

Thanks,

Alex

[Former Member]

Hi Alex,

During your transaction data load you can set selection on one currency type, also check your transformation file, are you mapping into two currencies?

Is there a routine in the transformation file?

Andy

[former_member186338]

Also may be some default.lgf script launched after load?

Vadim

P.S. Or write back badi...

[Former Member]

Hello All,

Thank you for your responses thus far. Yes I'm trying to load both currencies, my transformation maps 0CURTYPE of 10 to LC and B0 to USD. No I'm not running default logic, routine, or have a any write back BAdI.

I am expecting 2 records to come into BPC, however it is showing 4 in the package summary and the reject list shows it processing the same 2 records twice.

Alex

[former_member186338]

Try with single currency (1 record) and provide screenshots of upload process... Unfortunately not enough info to provide any suggestions!

Vadim

[Former Member]

1 ,ACTUAL,000018,BW_COPA_IS,VALUE,01160PS1400038101272,0000001030,USD,2013.01,ZFAGROSSSALES,-5696.76

1 ,ACTUAL,000018,BW_COPA_IS,VALUE,01160PS1400038101272,0000001030,USD,2013.01,ZFAGROSSSALES,-5696.76

Still loads in the same record twice.

Transformation File (Nothing in Conversion Section for my test scenario)

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP =

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=NO

MAXREJECTCOUNT=-1

ROUNDAMOUNT=

*MAPPING

CATEGORY=*NEWCOL(ACTUAL)

CUSTOMERSEGMENT2=0SALES_DIST

DATASRC=*NEWCOL(BW_COPA_IS)

KFACCOUNT=*NEWCOL(VALUE)

PRODUCTKBA=ZBRAND+0PRODH1+0PRODH2+0PRODH3+0PRODH4

REPORTINGGROUP=0PROFIT_CTR

RPTCURRENCY=*IF(0CURTYPE=*STR(10) THEN *STR(LC); 0CURTYPE=*STR(B0) THEN *STR(USD); *STR(NA))

TIME=*STR(2013.01)

ACCOUNT=*MVAL(ZGROSSALE|*NEWCOL(ZFAGROSSSALES)) *CONVERSION

[former_member186338]

Easy!

What do you try to achieve with this line:

ACCOUNT=*MVAL(ZGROSSALE|*NEWCOL(ZFAGROSSSALES))

Vadim

[Former Member]

Because normally I load in 36 different Key Figures. I removed the other ones for my example testing. This works 100% of the time normally and has never caused issues before. When I leave in the other 35 Key Figures, I get the same results, doubled for each Key Figure.

[former_member186338]

Test without MVAL!

Vadim

P.S. And show you conversion file!