Question:
This is what I have:
Characteristics/dimensiona: customer, sales org, plant, material, calendar week
Key figure: schedule line quantity
Customer sends weekly requirements for more than one weeks
Requirement: report comparing the schedule line requirements for any week(s) showing the net change for any reported week(s).
Simple? What is the way to show the net change in the results row underneath (instead of the usual sum)? Please let me know.
I would like to highlight (in a different color like alert monitor, if I can) if the requirement from the same customer for a reported week has changed so that users in one glance can know whether the requirements have changed.
Answer:
Let's give an example to see if I (we ?) understand correctly :
Week 37 : the customer 1 gives the following schedule :
Week 38 : 100
Week 39 : 200
Week 40 : 150
Week 38 : new schedule:
week 39 : 180
week 40 : 160
Do you want to see that :
Customer 1 week 39 -20
week 40 +10
???
If yes, you need to give us more informations about the structure (does calendar week mean scheduled week, do you have the information of the week when customer sent the schedule ?)
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Fred,
You are right. The report should show the difference the way you mention.
The calendar week here does mean the schedule line week (it is part of the time dimension). There is another dimension called snapshot week (you could say the week the customer's requirements were collected in the system) with calendar week as characteristic. This is the characteristic that will be used to compare via a variable input on the selection screen.
Please let me know if you need any more clarification.
Answer:
I suggest you to create 2 restricted KF, one giving the quantity required during week A, and the second giving the quantity required during week B. It's easy to achieve, by creating 2 different variables on the snapshot week. Hide (or not, as you wish) the 2 KF, and create a calc. KF giving the delta between KFA and KFB. After, you drilldown on the schedule line week.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Fred,
I appreciate your response.
I think you have understood what the requirement in general is. What you have suggested is to achieve the delta between the two KFs. That would be fine if I need to see the net change in another column. What I am (more specifically, the users are) interested in is seeing the net change right below the values in a calendar week (for the two snapshot weeks) in the third row (say, where the typical results row is). Do you know how we can do that?
Also, chew on this - if the number of snapshot comparison weeks is more than two, how can we color code different cells with the values to show the change from one week to another?
Thanks, in advance.
Answer:
For the colors, it's easy to think about conditions ...
For your first problem, harder. Maybe in creating structures, or with the Cell Editor... but no precise idea right now.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Fred,
Conditions won't achieve the coloring scheme highlighting a deviation from one week to next. Think about it.
Answer:
Sorry, I thought about exceptions, of course ....
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.