Macro should only be executed for periods of current month

[Former Member]

Hello Experts,

I am using fiscal year variant (FW) in which 4 periods exist for any month. Whenever I open the planning book, I will have to see only these 4 periods of the current month and Initial bucket.

I have a macro, that should be executed for all these 4 periods of the current month at any time during the month.

(aggregated sum of forecast of period 1 and 2 will be shown in bucket 2. aggregated sum of period 1,2 and 3 are shown in bucket 3, etc)

So, I have designed the time bucket profile with past as 1 month of Fiscal year variant FW and future of 1 month of Fiscal year variant.

My time bucket profile is 1 month - split into 4 periods of fiscal year FW.

1) The macro runs fine if the current system date lies in the second period through fourth period. But during the beginning of the month, when it is in the first fiscal period of month, it displays past 4 periods as 4 periods of previous month and 4 future periods of current month. I just want to display all buckets or periods of current month only. How can I achieve this?

2) So, during first week of the month, my macro runs only for past 4 periods and not for future 4 periods. But I want to run only from 1st period of current month till last period of current month. How to achieve this? Is there any macro function to overcome this? Or is there any standard configuration to avoid this problem?

Thanks,

Suresh

[Former Member]

Hello,

For the benefits of the others consultants, please indicate the good or the helpful answer!

Thanks, Marius

[Former Member]

Hi Surech,

In the planning book design, select check box "Visible" and choose the date from when you want to be visible the data in your planning book.

Thanks.

Regards, Marius 

[Former Member]

Hi Marius,

Thanks for the response.

But it's not quite helpful. Because, I can't go ahead and change the date every month. Once the things move to production, it's frozen. No changes to planning book/data view design.

Thanks,

Suresh

[Former Member]

Hi Suresh,

From your past time bucket profile you can choose from where you want to have visible values in the planning book. This is a rolling horizon. Normally it's not necessary to change the date each month.

Thanks.

Regards, Marius

[Former Member]

Hi Marius,

Thanks again. But, the macro code that I write, should be executed from the first period of current month to the last period of current month, even though, if the current system date is in the third period of the current month.

Also the interactive planning grid should show all the periods of current month as visible, even though I'm not in the first period of current month.

Thanks and Best Regards,

Suresh