NEED HELP ON LOOKUP

ccsamson · 2025-01-02T02:16:38+00:00

There was an error rendering this rich post.

Hello,

Good Day!

Need some professional help on how I can replicate the weeknum function from Excel to Anaplan. I am relatively new to this platform.

I have a module where I should be able to get the Peak Week from a date value (Peak Date).

» So it's like the Weeknum function using the 'Peak Date Mid" value.

I have another module which contains different weeks and corresponding range of such week as shown below:

It should be that when the Peak Date Mid value falls within the range of a specific week, it should return the Peak Week.

Note: That my Target Module is not dimensioned by T2 Week.

Hoping someone can help, I'm really stressed out by this. :(

Accepted answers

TristanS

@ccsamson is there a specific reason that you are using a custom "T2 Week" time list rather than using Anaplan's native time dimension as per highlighted fields in yellow below for the module "SYS06 Time Settings - Peak Week"? At any rate, to get to the final result you require, you will need to create a Day Period system module, e.g. "SYS05 time Settings - Day". In that Day module you will map what Week Period or "T2 Week" each day maps to. Would really be easier if you just use Anaplan's native time dimension but don't really know the constraints you as to the reason for the use of the custom time list.

All comments

TristanS

ccsamson

Hello @TristanS, thanks! I used it since our Fiscal Year starts in May. However, I’m unsure how to configure Anaplan’s native time dimensions so that it starts in May while still labeling the beginning of the fiscal year as Week 18 instead of Week 1.

ccsamson

Already Created a Day Mapping Module, and it already works

seymatas1

Hi @ccsamson,

Using dynamic/custom time instead of native time has its advantages and disadvantages.

One advantage is that you can create and manage subsets to reduce module sizes.

However, there are some disadvantages, like not being able to use certain time functions such as OFFSET.

If you set May as your fiscal year start in Anaplan's native time, the system automatically numbers the first week as Week 1, and this can’t be changed.

However, you can customize week names by removing the week number and using start or end dates instead. For example, you could name a week "W/c 28 Apr 24," which stands for "Week commencing 28th April 2024."

I hope this helps.

Seyma 🌷🙂

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
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
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…