Key figure display in planning book with respect to Time bucket profile

[former_member698542]

Hi,

I am loading a key figure to planning area from the info cube for the current month. When I review the key figure in planning book with monthly time bucket profile it shows 85 for the current month. In the same planning book with weekly bucket profile, it shows 55 from the current week and future weeks and the remaining 30 goes into the past weeks of the current month.

How to make the total quantity 85 to show in the current and future weeks only.

thanks and regards

Murugesan

[former_member209769 · Accepted solution]

Hi Murugesan,

Within the Planning Area, the data is stored at the lowest level granularity that you maintain in storage bucket profile. Then during display, system will decide what data to show depending on what kind of time bucket profile you use in the planning view, and the time based disaggregation that you maintain for Key Figure.

In this below case, what time characteristic do you have in cube? Is it date, week or month?

If it's date, check how much KF data is maintained on the dates which belong to week which has days both in this month/last month e.g. if I talk about Dec 2011, how much data is stored 1,2,3 & 4 th of Dec, 2011.

This data would appear in Dec in monthly view, but in week, it would appear in the week starting 28th November.

If data is maintained in cube in weeks, then you need to calculate how time based disaggregation would show it to you in months.

If it's months, then you would need to find out how much data would go to the days in the past week of the month.

The time based disaggregation may be causing you some issues, but in that case, I would not expect 30 out of 85 to go in the past week, unless you have data in cube in days.

Data shown in weekly view for week starting 28th Nov should ideally be a small proportion of 85, unless you are using a time stream/fiscal year variant, due to which most of December is in holidays. The only other exception I can think of is that you have data in teh days mentioned above.

It would be best to help the business understand this disaggregation logic, rather than thinking of manipulating the data to shift to a later week.

If this logic doesn't explain your situation, then please provide the date/week/month at which you have data in cube, and what quantity.

Thanks - Pawan

[former_member698542 · Accepted solution]

Hi Pawan,

The data in the info cube is in moths only (e.g. 112012,122012 etc).

When I see the planning book in monthly buckets it shows 85 for December 2011. When I see with weekly bucket profile it show only 55 in the current and future weeks and the remaining 30 it shows in the past weeks of December 2011.

[former_member209769 · Accepted solution]

Hi Murugesan,

Please share the details of the time bucket profile for your weekly planning view.

If you use any fiscal year variant, then please share the details of the same as well.

Basically, we are trying to find out how many working days from last week of November are falling in last month, and how many fall in current month. Also, need to know for the current month and last month, how many working days lie per week of the current month and last month.

Oh, and also how much data do you have in November month? Some part of that data also would be visible when you see last week of Nov.

Data in last week of Nov = pro-rata data for working days in last week of Nov falling in Nov (from total data in Nov) + pro-rata data for working days in last week of Nov falling in Dec (from total data in Dec).

See if this explains your data situation.

Thanks - Pawan

[former_member698542 · Accepted solution]

Hi,

The info cube data is stored in MONTHS.

The planning book is using time bucket profile in weeks. If the key figure is 100 for month January 2012. The key figure is showing only 30 in the future weeks. The remaining is going to the weeks of Jan 2012 which already past.

How can we make the planning book to show the key figure quantity to distribute from month to only the future weeks of the current month.

thanks and regards

Murugesan

[former_member209769 · Accepted solution]

Hi Murugesan,

If your data in cube is only in months, then data would come from cube to planning area in months. You would have time based disaggregation in planning area, so that the data would split from months to all weeks of the respective month.

The data that you see is as per the standard behaviour.

Why do you want to get the month's data only in the future weeks? I haven't heard about such kind of requirement earlier.

Future weeks will keep on changing, so even if you want to use some macro to shift the data from old weeks to the future weeks, you would need to run some job regularly (daily or at least weekly).

Thanks - Pawan

[former_member187488]

Hello,

There's a setting in the material master /sapapo/mat1.

It's "peiod split" field on "SNP2" tab, "SNP Demand Profile" group.

Please check the F1 help of this feild for further information.

Maybe you can use setting '2' to meet your requirement.

Best Regards,

Ada

[former_member698542]

Dera Ada,

I am not using SNP. I maintain the period split 2 in SNP 2 view from material master and tried. The same issue.

thanks and regards

Muruegsan