Skip to Content
0

Problems with load transaction data without movementtype

Aug 23, 2017 at 12:57 PM

39

avatar image
Former Member

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

source-infoobj.png (354.9 kB)
bpc-infoobj.png (879.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Aug 23, 2017 at 01:06 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

It does not take values with empty movementtype.

0

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

0