Skip to Content
avatar image
Former Member

Dynamic Rolling weekly periods in Planning Book

Dear Gurus,

Is there a way to create a dynamic weekly buckets in SNP/DP planning books? That is , weekly bucket start data is not fixed (to Monday), first period should start from today (Current day, eg:Wednesday) till 7 day (till next Tuesday) and second period should start from next Wednesday and likewise. So first bucket start date is always current day.

I didn't find any userexit to modify bucket start date and end date.

Thanks in advance,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 21, 2010 at 10:33 AM

    Hi Niranjan,

    In the define planning book screen under data view tab,

    check the fields "from" dates next to TB profile ID (past)

    Regards

    R. Senthil Mareeswaran.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 21, 2010 at 03:00 PM

    Hello Niranjan,

    This is not technically feasible. Because the start periods and end periods are defined in the fiscal variants. If you define your own fiscal variants also, you can set a static day as start day. For example always Wednesday as the start day and Tuesday and the End day of the period is possible. However dynamic rollover is not possible because. If you modify the Fiscal variants, you will have recreate time series, which would result of loss of LC data.

    I am just curious as to why you want buckets based on the current day. If you define a fiscal variant with weekly periods. The starting for the current week will be today till the static end day you fixed (for eg: Tuesday) and next day start day will be Thursday and the end day will still be Tuesday it wont rollover to Wednesday.

    Hope this helps.

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      That is a good way to proceed. Pls ensure that the row is not editable so that you can avoid accidental changes to the totals column.

      Thanks

      Mani