Distribution process

[Former Member]

Hi All,

I have the following structure in my BPS cube

Country, Material, Sub seg grp, Customer, Var Mgn.

#,#,137,#, 1000

BA, 4566, 137, 8003, 135

CA, 3456, 137, 8004, 126

US, 1234, 137, 8002, 100

#,#,135,#, 2000

BA, 3456, 135, 8008, 65

CA, 7658, 135, 8005, 77

US, 9846, 135, 8009, 50

I would like to distribute the first records variable margin 1000 into the remainining 3 records. And i need to maintain the current var mgn ratio.

I tried the Distribution by Key, Ref Data, Ref key. Nothing helps to me.

Am I missing here, Please give me some tips.

Note: BW 3.5 BPS.

Thanks

Billy

[Former Member]

Hi,

Distribute with ref data shoould work in you case. What happens when you try to do that? Which chars do you have in ref. data and in the fields to be changed etc.?

Regards