Difference between Calendar Type options - "Weeks"

augustus.perera

Context :

In Model Calender, Calender Types reflects 3 different options like

a) Weeks: 4-4-5, 4-5-4 or 5-4-4

b) Weeks: General

c) Weeks: 13 4-week periods

In exl there is "weeknum" to interpret the week number in a given date.

Appreciate a clarification on different week formats provided by default.

Cheers.

Accepted answers

All comments

ArunManickam

Hello @augustus.perera ,

Great question.

It is explained well here in Anapedia

Countries / Companies have several ways, standards and traditions, to report data in week, month, quarter and year.

For someone, calendar month and quarter is good.

For someone, they report by 4-4-5 quarters (4 weeks in the first month, 4 weeks in second and 5 weeks in the third). Typically every quarter will have 13 weeks. An year is not exactly 52 weeks, to compensate this you have a 14 week quarter once in every 5 or 6 years. Once you configure data by weeks, reporting it by calendar month needs additional effort. 4-4-5 fiscal month and calendar (Gregorian) month is not same.

General week is simply weeks without rolling upto quarters and months. You can map the general week to a custom quarter as defined by business. Only in general week, you have a model calendar that is less than a year. In all other options, you can add time to your model calendar in multiple of years only.

Based on requirements, the solution architect has to evaluate and choose the right setting for the model.

Thanks

Arun

augustus.perera

Thanks mate.

I have another question in level 1 model building appreciate if you can assist me on it as well.

ArunManickam

Sure, let me know your question or give me the link if you had already asked in Level 1 forum

Thanks

Arun

humze

Great work Arun,

I have never seen such a good explanation before.

keerthipatiaditya

Thanks for the info. But can explain 4-4-5 ,4-5-4 or 5-4-4 ...

What do the 4-5-4 individually stands for...??

4-?

5-?

ArunManickam

Hello @keerthipatiaditya ,

A quarter has 3 months always and 13 weeks mostly or 14 weeks sometimes (Once in 5/6 years)

13 weeks can be distributed as follows,

4 weeks in first month

4 weeks in second month

5 weeks in third month

Thats what it stands for 4-4-5.

Some customers follow, 5 weeks in first month etc and so on.

Thanks

Arun

keerthipatiaditya

Tqsm

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…