Characteristics and KF's in lead column. - Urgent

[Former Member]

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

[Former Member]

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

[Former Member]

Hey Filip,

Thanks for your answer but what you are suggesting is what i had proposed to the users earlier.

we are showing the output in Excel.

The users said that there can be a possibility that there exists overlapping b/w 10 or more managers.Then it would involve huge horizontal scrolling.

Thats why he wants to see every managers planned data in the same col. with its version in the prev col.It becomes easier for him to see all planning figures of each manager.

Do Suggest if sme other alternative strikes you.

Thankyou

Priya

[Former Member]

Hi Priya,

I don't see an easy way of achieveing your requirement.

But, still there is a workaround as you are working on excel based layouts.

Look into possibilities of SEM macros & see if you can take advantage of these.

As yours looks like more of a purely customized requirement, i feel Macros are the only way to go unless someone else gives a better idea.

We had a similar requirement at one of my previous projects where we had 11 characteristics & 10 dynamic key figures (KF's might be ranging from 10 - 100 based on the variable selection).

As you can see with 100 key figures (columns), user has to depend on horizontal scrollbar. So, I took advantage of SEM macros & customized the layout of 11 characteristics & 100 key figures to fit in a single page without the need of horizontal scroll bar.

Hope it gives some insights.

Hari Immadi

http://immadi.com

SEM BW Analyst

[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