In our system, the system time zone is maintained as EST. I have assigned a planning calendar (time stream ID) in the Storage Bucket Profile.
In the planning calendar, I maintained the time zone as EST.
When I try to disaggregate in planning book from Monthly to Weekly, it is disaggregating by taking UTC as the time zone. Because of this, I am not getting correct disaggregation. For example, in the planning calendar, I have work days from Monday to Friday with 00:00:01 to 24:00:00. Because the system takes UTC as the time zone and 24:00:00EST in Friday is something like 05:00:00UTC in Saturday, it disaggregates some quantity to Saturday also.
I confirmed this by changing the time zone in the planning calendar to UTC. After changing the time zone to UTC in planning calendar, it disaggregates exactly as we expected.
My questions are,
1. Will DP always use UTC as the basis for its disaggregation?
2. Do we need to maintain UTC as the time zone in the planning calendar?
3. If we maintain UTC in DP and when we release the forecast to SNP and do the planning in SNP/PPDS with time zone EST, will there be any inconsistencies?
4. Is there a way to make DP to consider EST as the time zone for disaggregation?
Thanks in advance for your help on this.
Please let me know, if you need any more details on this.