Set up custom time scale

My current model is using a fiscal calendar e.g. FY23: 1 Jul 2022 – 30 Jun 2023.

However, I have a specific use case, where I need to build a module that uses a calendar year e.g. FY23: 1 Jan 2022 – 31 Dec 2022.

Is there a way to resolve this use case? Based on current research, I would need to create a fake time list/module, however I can’t figure out how to map this fake time to the real time (i.e. native time in Anaplan).

Thanks,

Accepted answers

All comments

StevenBeerthuizen

You can have a look at an example custom time scale in this app: https://community.anaplan.com/t5/learning/Modeling-Examples/ba-p/28084
Kr,
Steven

Alison25

Hi Steven,

Thanks for your response. Based on your link below I have done the following:

1. Created a list for fake months, called "Calendar Months" - E.g Jan, Feb, Mar, Apr, etc.. Dec

2. Created a mapping module dimensioned by Time (months) and included a line item (Calendar Month) formatted by the list of fake months. I have had to manually map each real month to the fake month per the attached screenshot. However was wondering if there is a more efficient way of doing this, as this is quite cumbersome?

I would then hypothetically use a LOOKUP function in my calculation module.

StevenBeerthuizen

You need to have the year rollup also, right? And if you use the same naming as the real time, you can easily use FINDITEM on the time dimension.
Kr,
Steven

edit: you can create your custom time from an import using the real time....this way you can assure you have the same naming

andrewtye

Wonder if this might help? https://community.anaplan.com/t5/How-To/Modeling-Video-Series-1-Flexible-Time-Mapping/ta-p/93234

fabien.junod

Hello @Alison25 ,

To automate the mapping Time > Calendar months, you can add a code to your list items corresponding to the month #

Then use FINDITEM in your SYS03 module

Alison25

Hi @fabien.junod

Thanks this was super helpful. Just a last question - in my current list it does not include the year, i.e. Jan, Feb, Mar, Apr, May ..... Dec. If I wanted to do this across multiple calendar years (e.g. Jan 22 - Dec 22, Jan 23 - Dec 23... etc), how would I solve for this?

Would I need to make edit my existing list to include ALL the required months and respective year?

Thanks

Alison

fabien.junod

Hello @Alison25

Are you saying that you need your custom time scale to include the year?

If that the case, you could:

1) Create a custom time scale that includes month and year. Then add a code like "month#_year" to automate the mapping

2) Create two lists, one for the month and one for the year.

But taking a step back: What are you trying to achieve?

You mentioned that you need a time scale that aligns with the Calendar Year but you Fiscal Year starts in July

Can't you use a time range that includes the calendar year that you need?

Example: if you need the period Jan 2022 to Dec 2022, you could dimension your module by a time range that includes FY22 (July 2021 - June 2022) and FY23 (July 2022 - June 2023). Then you use filters and conditional to make sure only Jan 2022 - Dec2022 is visible and populated

Monicajain

Hi @fabien.junod If you go with using filters and conditions to make sure only Jan 22-Dec 22 is visible, I am curious how we will get sum of quarter and year. Can you do it?

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…