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
Message was edited by: Priya Gangwani
Hi,
The easiest is to not show the version number characteristic.
Create the layout as follows:
'CustGp', 'Biz_Unit', 'sales_Area', 'Prdct_Div', 'Billing2006', 'Target_2007 A10', 'Target_2007 B10', 'Target_2007 A10'.
S1, B1, SA1, Div1, 4500, 5000, 6000, ____ .
From a user point of view, this layout is more intuitive.
After all, why should the billing be shown 3 times.
You could even show the difference between target A10 and target B10 to make it easier for the user to fill column Z10.
You can achieve this by putting the version in the 'data columns' on the first screen of your layout and then create several lines in the 'data columns' tab and enter the correct version (A10, B10, Z10) in the different lines.
You will also need a line for billing and will be obliged to assign a version. Billing generally has no version so enter '#' not assigned.
Please assign points if this helped you,
Best Regards,
Filip
Add a comment