I think this has to be named as “Change Calendar” series š
You can check these post on how to change history year, start month
This one is also on the same line where we’ll change the weekly distribution (4-4-5, 4-5-4, 5-4-4, Even)
Some insight on “Weekly Distribution”
Weekly distribution sets the monthly distribution pattern, based on the number of fiscal weeks in a month. This determines how data in summary time periods spreads within the base time period. When users enter data into summary time periods, such as quarters, the value is distributed over the base time periods in the summary time period.
If you select a weekly distribution pattern other than Even, Planning treats quarterly values as if they were divided into 13 weeks and distributes weeks according to the selected pattern. For example, if you select 5-4-4, the first month in a quarter is considered to have five weeks, and the last two months in the quarter have four weeks.
Let’s look at the spreading pattern for a 4-4-5 weekly distribution when there is no value for all the children.
So if this was 4-5-4 distribution then
Jul will be 40
Aug will be 50
Sep will be 40
Planning holds this information in SUPPORT445 column of HSP_SYSTEMCFG table
- 0 – None
- 1 – 445
- 2 – 454
- 3 – 544
Let’s imagine a scenario where customer would like to have 4-5-4 distribution instead of existing 4-4-5
You can run the below given SQL
update hsp_systemcfg set support445=’2′;
update hsp_account set use_445 =’2′ where use_445 =’1′;
commit;
Re-start Planning and then you are ready to go, Login to Planning and see whether the changes are in place.
Nicely explained..thanks!
Celvin,
You might want to change your code from:
update smp_plnadmin.hsp_systemcfg set support445='1';
update smp_plnadmin.hsp_account set use_445 ='2' where use_445 ='1';
commit;
to
update smp_plnadmin.hsp_systemcfg set support445='2';
update smp_plnadmin.hsp_account set use_445 ='2' where use_445 ='1';
commit;
Otherwise, great post — I just used this at a client where the admin selected the wrong time distribution option on application create.
Regards,
Cameron Lackpour
@Cameron Lackpour
Thank you for pointing that out.
Celvin, in your post you hve mentioned "Re-start Planning and then you are ready to go, Login to Planning and see whether the changes are in place."
The changes actually take place when you restart all the EPM services.
@amit it is dependent on planning services. Why do you think you need to restart all EPM services?
Hi Kelvin,
Any idea how you would modify it from even distribution to 544 ? How would you identify the records in account table that need to be set to 3 ?
Thanks in Advance!
Check what you've in SUPPORT445 column and change it to 3. For Even distribution I don't think the accounts will be using USE_445, you can run a distinct query to find that out.