Dynamic Fake Weeks to Fake Months?

SirValdemar

W2M_ListConfig.png

W2M_SysBluePrint.png

W2M_SysModule.png

Hello )

Need to run FakeWeeks and FakeMonths to support a Optimizer-setup.

As a part of the requirement I need to be able to sum FakeWeek-data into FakeMonth-data. As the fake time lists are dynamic and used for a forecast which moves with the current period of the model I can not use a manual mapping.

I am close I think, but could really benefit from a sharp mind to help me figure out how to automatically fill out the red data on the "W2M_SysModule" - or figure out a better/simpler solution if possible.


Lists are setup via the support of:

https://www.youtube.com/watch?v=hD7Wt4wcxwM

Furthermore been diving into the following material, but not managed to figure it out yet..

https://learning.anaplan.com/course/view.php?id=1267
https://community.anaplan.com/t5/How-To/Modeling-Video-Series-1-Flexible-Time-Mapping/ta-p/93234

nvilkko

Hi @SirValdemar,

I think it would make your life easier if you could create a relation between the native and fake months with the month number or name if possible.

It seems that your Fake lists are numbered lists, is there a reason why? If you used normal list, then you could use the finditem directly on the name. E.g. Finditem(OMonths, name(Month)) Or I think you could also populate the OMonth_Num, if you generate that same sequential numbering in the native month settings module. Then you could lookup the number based on 'Month'.

Let me know if any questions.

Thanks,

Niko

seymatas1

Why not give codes to the months and use those in your module instead of using ISFIRSTOCCURRENCE and RANK formulas? Am I overlooking something?

Seyma 🌷🙂

seymatas1

https://www.youtube.com/watch?v=hD7Wt4wcxwM
In this video, they set it up as numbered lists but as @nvilkko mentioned, there is no need to set up dynamic time as numbered lists.

SirValdemar

Thanks you two ,-) Managed to find a solution through your inputs