Time Stream not Recognised

[Former Member]

Hi

For use in Demand Planning, I have a fiscal year variant that determines the structure of my months, which is working ok. I have a Time Stream ID that I thought would determine the structure of my weeks, but it is not working. For example the last week of 2008 I have specified as being:

From From Time To To Time

22.12.2008 00:00:00 31.12.2008 24:00:00

However in my data view the week starts on 22.12.2008 and a new week starts on 29.12.2008. I wanted the week starting 22.12.2008 to go through to 21.12.2008

I have assigned the Time Stream ID in the ‘Maintain Periodicity’ transaction with and selected weeks and PostPeriod (along with my Fiscal year Variant for months).

Does anyone know why the range I have specified in my Time Stream isn’t working?

Thanks for your help

[Former Member]

First of all you need to consider that this new FYV should be entered at maintain periodicity, and it is very important because you will associate this to your planning area and then every parameter will be locked.

With your FYV defined as you want you should not have any problems for future unless you would have to define every periodicity year by year.

Good luck!

[somnath_manna]

Check the Time Bucket Profile (transaction /SAPAPO/TR30) being used in the Data View for Future. You need to have the Time bucket Profile defined with the Fiscal Year Variant defined. As regards the week to month (fiscal year variant) it would always be an issue as the week is mapped to Gregorian calendar and not the Fiscal Year Variant. But I do not understand why you expect to see your week start from 22.12.2008 all the way till 31.12.2008 (assume 21.12.2008 is a typo).

Thanks,

somnath

[Former Member]

Hi

Just to understand further, in your planning view what Time Buckets profile have you defined. It sounds like you have Weeks in your Time Buckets rather than a Posting Period.

The Time Stream ID is used to collate the information into the defined time periods in livecache, the Time Bucket profile is used to display the information in "buckets" of time in the planning view.

I am therefore assuming that you have a Time Stream ID which has the final period of the year greater than a week. To show the same in your planning view you will need to have a Time Bucket profile that reflects this time period.

Hope that helps

Regards

Ian

[Former Member]

Thank you for your reply.

I have a weekly time bucket profile, which from what I gather from your last paragraph is incorrect?

How do you create a Time Bucket of longer than a week? We are already using a FYV for determining monthly buckets.

Thanks

[Former Member]

If you have a FYV for monthly buckets, you will need to create one for weekly buckets, though I must admit I have never done this (!). You will then need to reference this FYV in your Time Bucket definition using basic periodicity type 'P'

Regards

Ian

[Former Member]

Is it possible to have an FYV for both weekly and monthly at the same time? If so, can you please share with me how you do this?

I have an active FYV for months that is working as specified and I can't see how you then add one for weeks as well and use them both in the same Planning Area

Thanks

[Former Member]

You can define two separate FYV in SPRO but the issue is that I don't think you can have more than 16 periods in a FYV, I'm sure someone financial can confirm this?

The FYV is not referenced in the planning area, it is referenced (indirectly) against your data view in the planning book. On the Data View tab in the planning book maintenance screen you have the fields for the TB Profile ID (future and past), it is in these Time Bucket Profiles that you assign the FYV. So all you need to do is have a separate TB Profile for each FYV and a separate Data View assigned to each TB Profile.

But as I say, I think your issue may be that you cannot use 53 weeks in a FYV.

[Former Member]

Thanks again Ian for your reply.

I have created another FYV, as required, for weeks, and also created the corresponding time bucket profiles. However I cannot select both the month FYV <i>and</i> week FYV in dataviews for the same planning area.

I thought the FYV was referenced by the planning area when you specify the FYV in your Storage Bucket Profile?