Hi,
I have a module where teams are required to input weekly but at a specific schedule
e.g. week ending 7th, 15th, 23rd, and last day of each month.
Is it possible to configure this?Thanks
@CommunityMember113484
If you model is using a weekly default calendar you can configure the format to be 'week ending.'
If your model is using a monthly default calendar it is not possible to use a time dimension to achieve this.
However, you could create a list and use this in your module.
You will then need to map this list back to a monthly time period using a systems module.
Hi Chris,
My model is dimensioned by weeks already. I've now changed to week ending, but I need it specifically for the dates mentioned each month: 7th, 15th, 23rd and last day of month - is this possible?
Thanks
You can set the correct sequence of weeks by updating the 'end of fiscal year'
Sorry for not getting this - I'm not getting w/e 7th, 15th, 23rd and last day of month?
It is not possible to create a calendar where the week ends land on the same day numbers each month as the length of each month is not equal.
How many weeks are you expecting to see in each month?
Are you using a 4-4-5 or other combination of weeks to build you model calendar?
Can you post a screenshot of your current time settings.
Yes using the 4-4-5. Current time settings below:
What you are asking for is not possible.
The closet I have managed results in the following;
Use the following settings;
The months simply do not follow the required pattern to generate what you are looking for.
Ah okay, thanks for your help. I did something similar in 2021 to get close.
Thanks again,
Hi, I have a doubt in level 2 sprint 3.4.3 Activity: Create Country Summary Module I did the following :- Step 1 → Created a new column "Country Made in" in SYS08 SKU details Step 2 → Wrote a formula Parent(Supplied By) to bring parent of the location i.e. country in "Country Made in" column Step 3 → I have written the…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…