Scenario Question for Time Settings.

IF MODULE A = CUSTOM CALENDAR & FY19 DATA,

MODULE B = MODEL CALENDAR of FY21,

then how can we get MODULE A DATA to Module B as FY21?

Accepted answers

It's because your Target Calendar doesn't have source period in it. This means there is no one-line solution, but let me give you two alternative solutions (either 1 or 2 will do the work):

Please note that you might already have "Calc_2" in some time settings SYS module (if not, build it there), and can utilize it here and in the future in multiple modules.

All comments

M.Kierepka

Hi,
Probably you need to use lookup.
Create SYS module with dimension of Time (what you have in Module

, format of line item as Custom Time (so what you have in module A), and then map items from one list to another. Then, in module B you will do something like "Module A.Value[LOOKUP:SYS.Time mapping]"
Hope it helps! (if not, please provide more details)

muizzsk9890

Hi @M.Kierepka .

Please refer to the Screenshots below:

1. Module A: Timescale= Months, Time Range = Custom Calendar (Ref. Image MS Teams-1)

2. Module B: Timescale= Months, Time Range = Model Calendar (Ref. Image MS Teams)

3. System Module: Timescale= Months, Time Range = Model Calendar (Ref. Image MS Teams)

4. The error I got is Datatype mismatch along with the formula for lookup suggested by you.(Ref. Image MS Teams- 5)

Is there anything else we are missing out or going a wrong path??

MicrosoftTeams-image_(1)_131906.png

MicrosoftTeams-image_131906.png

MicrosoftTeams-image_(3)_131906.png

MicrosoftTeams-image_(2)_131906.png

MicrosoftTeams-image_(4)_131906.png

MicrosoftTeams-image_(5)_131906.png

M.Kierepka

It's just miscommunication - I thought "Custom Calendar" is some list you created with different time structure than default Anaplan Calendar. But your "Custom Calendar" is just Time Range - Anaplan shouldn't have problems with mapping values between them.

About solution: In target line item, put formula "LAG( Module A.Sales, 24, 0)"

Explanation: LAG allows you to bring values with offset in time. 24 is the number of months between source and target (I assume you want to always pick numbers from "current year minus two"). The third argument, 0, tells Anaplan what to do if it will try to get values outside the range.

More about LAG formula: https://help.anaplan.com/3064919f-964e-4b84-be56-15f0e127e371-LAG

muizzsk9890

Hi Sir,

The formula was applied but the Values did not come up & still showing as 0. Please refer below screenshot.

MicrosoftTeams-image_(6)_131931.png

M.Kierepka

It's because your Target Calendar doesn't have source period in it. This means there is no one-line solution, but let me give you two alternative solutions (either 1 or 2 will do the work):

Please note that you might already have "Calc_2" in some time settings SYS module (if not, build it there), and can utilize it here and in the future in multiple modules.

muizzsk9890

Hi @M.Kierepka

Thanks a lot sir. The Calc 2 method worked after implementing this line item in the SYS module & the Lookup formula returned the 2019 values.

Regards,

Quick Links

Can you help?

Unanswered questions

Anaplan Export (Tabular Multiple Column): Saved View Line Items
When exporting from Anaplan using "Tabular Multiple Column", will the export include only the line items saved in the saved view, or will it also export line items that are excluded from the saved view?
Cloudworks Status "Auto_Deactivated"
Have noticed that in the last couple of days a couple of Cloudworks integrations have got a status of "Auto_Deactivated". Couldn't find anything in Anapedia and wondered if anyone knew what this was about? Seems to be something about the schedule as deleted the existing one, added it back and is now running fine but is…
Anaplan Polaris - ITEMLEVEL Question
Hello, I am trying to understand how the ITEMLEVEL function works. I am reviewing the example shown in Anapedia (https://help.anaplan.com/itemlevel-756d1428-5f1d-4d79-8274-d075a1bd312f) but I do not understand how Result 1 is calculated. For example, why does California returns 0 but Texas 4? Also, Spain returns 3 but UK…