Problems with load transaction data without movementtype

[daniel_cepok2]

Dear Experts,

we have some problems with load transaction data via Data Manager from BW.

The problem is, when I load a transaction data from BW f.e. for one

ITEM: 10130320 which has

INTERCO: PG1220 and value on

MOVEMENTTPE: 100 : 725.110,58 EUR and

NO MOVEMENTTYPE: -725.110,58 EUR.

I have in a transformation file mapping:

MOVEMENTTYPES = *IF ( *STR() + 0MOVE_TYPE = *STR() then *STR(END); 0MOVE_TYPE)

So BPC should take both values put it on MOVEMENTTYPE: END

But here is the Problem, BPC takes only the value of 725.110,58 EUR which is on the MOVEMENTTYPE 100 and ignore the value which is without movementtype. So I have a difference.

How can I say BPC to take both values and not just the one with the MOVEMENTTYPES.

My script logic for the MOVEMENTTYPES in DEFAULT, which write me the value on MOVEMENTTYPE 100 to END is

:

//Write Movementtype's on END
*XDIM_MEMBERSET MOVEMENTTYPES=BAS(A),BAS(699),BAS(599)
*XDIM_ADDMEMBERSET MOVEMENTTYPES=BAS(A),BAS(699),BAS(599)
*WHEN MOVEMENTTYPES
*IS *
*REC(FACTOR=1, MOVEMENTTYPES = END)
*ENDWHEN
*COMMIT

The Report from BW on the source InfoObject and then on the BPC InfoObject see attachement.

Hope you can help here to get all values to BPC

Thanks

Daniel

[former_member186338 · Accepted solution]

Strange line:

MOVEMENTTYPES = *IF ( *STR() + 0MOVE_TYPE = *STR() then *STR(END); 0MOVE_TYPE)

Has to be:

MOVEMENTTYPES = *IF(0MOVE_TYPE = *STR() then *STR(END); 0MOVE_TYPE)

Empty will go to END, Non empty - to the required movementtype

Not clear what do you want to do with default logic...

First test without default.lgf

[daniel_cepok2 · Accepted solution]

I changed the line and the problem is the same, the value does not change.

It does not take values with empty movementtype.

[former_member186338 · Accepted solution]

I do not see 0MOVE_TYPE column on your screenshot for source BW cube... Are you sure you have data?