Conversion file problem (Distributing values)

[former_member671850]

I am trying to distribute a source field in to 2 components (on %age wise) when it comes from BW to BPC ...Below is the conversion file I am making to distribute value >>>>I am picking ID0003 from the source and distributing it in to Internal source in FX01 by 40% and in FX02 by 60%.>>>PROBLEM I am facing is when I run package after validate it... is that the package only take the first conversion of ID0003 to FX01 by 40% and it neglect the second distribution....

I done it by making the distribution through 2 conversion files but in this case i have to run package for 2 times for distribution values but I want it to be done by running package by once as I have several more these kind of jobs and running package again and again doesn't looks feasible...

EXTERNAL	INTERNAL	FORMULA
ID0001	FX01	VALUE*1
ID0002	FX01	VALUE*1
ID0003	FX01	VALUE*.40
ID0003	FX02	VALUE*.60
DG0001	FX02	VALUE*1
DG0002	FX02	VALUE*1

[former_member186338 · Accepted solution]

Hi Rai,

It's not supported. Alternatives: try badi approach or simply import full amount on FX01 and then run default.lgf automatically after import:

*WHEN ZOUTPUT

*IS FX01

*REC(EXPRESSION=%VALUE%*0.6,ZOUTPUT=FX02)

*ENDWHEN

*WHEN ZOUTPUT

*IS FX01

*REC(EXPRESSION=%VALUE%*0.4)

*ENDWHEN

Vadim

[former_member671850 · Accepted solution]

Thanks Vadim>>It worked and it also generate the results in BW cube as desired..