How to breakdown the calendar month onto smaller parts?

YuriPinchuk

Hi,

While using Month/Quarter/Year Calendar type I need to breakdown the calendar month onto smaller parts:

decades (1-10, 11-20, 21 - 28/29/30/31) or
calendar weeks, which can be complete: Sun - Sat, or incomplete)

Let's take July 2022 as an example:

Jul-22-w1: 01/07 - 02/07 - incomplete

Jul-22-w2: 03/07 - 09/07 - complete

Jul-22-w3: 10/07 - 16/07 - complete

Jul-22-w4: 17/07 - 23/07 - complete

Jul-22-w5: 24/07 - 30/07 - complete

Jul-22-w6: 31/07 - incomplete

How can I do this?

Comments

RavinderB

You could create time ranges to modularize the calender settings

ie https://help.anaplan.com/1d28b6e4-184b-4ba2-990c-defcaf65bde6-Time-ranges

Here you create specific time ranges based on the time settings you require eg week 1, month 2 etc

Regards

YuriPinchuk

Sorry, don't get how to do it.

https://help.anaplan.com/16731ae9-6d65-4b72-a4ab-40ee64527b51-Time-Range-fundamentals

Quotation:

Note: The minimum length of a time range is one year. The maximum extent of a time range is (nearly) 100 years with the earliest being FY1981 and the latest FY2078. If you choose the earliest available Start Period of FY1981, the maximum number of years is 98. If the Start Period is FY2078, then the maximum number of years is 1.

RavinderB

You are correct, the week breakdown for time ranges is not possible.

If you had a different calender type e.g. based on weeks; then time functions such as weekvalue, weektodate could help.

I will try to explore further.

Regards

RavinderB

Another option you could explore is to have your time reqts set as lists, and use this instead of the standard TIME dimension.

You will have to set these up as lists and import data accordingly; but this is a possible solution.

Regards

Ravinder

YuriPinchuk

The idea to replace the standard time dimension looks dangerous.

I think I've found the solution. I created a new module Time Settings Details with a Day timescale and with items and formulae below

With this module, I can easily extend it to all timescale specifics needed. This approach is similar to one I have with Power BI calendar dimension.

However, I appreciate any comments or alerts regarding the suggested solution.

Regards,

Yuri

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…