Skip to Content
author's profile photo Former Member
Former Member

Characteristics and KF's in lead column. - Urgent

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

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 27, 2006 at 08:53 AM

    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 comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Hari,

      Thankyou for your suggestion. I think you are absolutely right in saying that the issue at hand can only be solved through Macros.

      But so far i have written Macros in Excel only.

      Are they different from SEM macros ??

      Could you share a small piece with me to clarify my confusion.

      or you could mail me a code smippet at priyagangwani@gmail.com

      Thankyou soo Much

      Regards

      Priya