Dynamic Fake Weeks to Fake Months?

SirValdemar · 2024-08-30T07:31:39+00:00

There was an error rendering this rich post.

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

Accepted answers

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 🌷🙂

All comments

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.

Let me know if any questions.

Thanks,

Niko

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.

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 🌷🙂

SirValdemar

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

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled