Characteristics and KF's in lead column. - Urgent

25 Views

Hello Gurus,

i have a specific problem.

in my layout i have chosen KF's in data cols.

i have 5 chars in Lead cols(including version) and 1 KF( for planned data) in Data Column.

The layout looks like this:

'CustGp', 'Biz_Unit', 'sales_Area', 'Prdct_Div', 'Version', 'Target 2007'

S1, B1, SA1, Div1, A10, 5000.

S1, B1, SA1, Div1, B10, 6000.

S1, B1, SA1, Div1, Z10, _____

This screen is meant for the consolidator who would resolve the overlapping(and store it wth version Z10) of planned data between Manager A[wth Version A10] and Manager B[ with B10].

Now, the issue is that the managers(A &B) plan the target w.r.t Billing Data of last year.

Hence, Billing info should be visible to the Consolidator as well.

So the required layout is:

'CustGp', 'Biz_Unit', 'sales_Area', 'Prdct_Div', 'Billing2006', 'Version', 'Target_2007'.

S1, B1, SA1, Div1, 4500, A10, 5000.

S1, B1, SA1, Div1, 4500, B10, 6000.

S1, B1, SA1, Div1, 4500, Z10, ____ .

That is : i want to include 1 KF in lead columns in b/w other chars.

How do i achieve this ??

although the case needs to be simple lead columns ( as it wud at run time pick the data from transaction Cube)

PLEASE PLEASE PLEASE HELP !!!!

nice suggestions would be generously assigned points..

Thanks .

Priya

P.S: i am on BW 3.1

Message was edited by: Priya Gangwani