Identifying REAL First/Last Month Monday Dates

Hello everyone,

Please see the picture enclosed.

I am trying to get Anaplan to identify the first and last Monday-dates of a given month, but I keep getting the wrong results due to the native calendar setup. Can anyone help me with a workaround? Maybe through convertering it into text and then into values and then setting the min/max and then convertering it back again? I keep hitting the wall.

Mondays_152976.png

Accepted answers

ManjunathKN

Hi @SirValdemar,

It works perfectly fine for me, My native time calendar is

you can keep the module timescale to Day only, If you keep it to month, the line items are in subsidiary views which impacts the performance. if you want to see only months then put a filter from system module.

now, what is your model timescale?

Thanks,
Manjunath

All comments

ManjunathKN

Hi @SirValdemar,

It works perfectly fine for me, My native time calendar is

SirValdemar

Thanks ManjunathKN,

Really appreciate it )

Unfortunately I need to ensure the weeks are ISO8601 aligned, and have only been able to do so with the enclosed image of the time-configuration. But it would certainly be handly I could for this module or line item only dictate that it should use the general calendar setup.

Is it possible to get the same results you have with my calendar setup you reckon?

TimeConfig_152994.png

ManjunathKN

@SirValdemar ,

I dont think we can bring it into 4-4-5 configuration(without heavy calc). can you create a module with native month time scale and do this calculation there and bring it into 4-4-5 config module using Monthvalue formula. didnt test this, let me know if you dont get results.

Thanks,
Manjunath

SirValdemar

@ManjunathKN

I believe that will give me the same challenge as posted initially; or maybe I am misunderstanding?

SirValdemar

For anyone else having this issue.

Solved by setting up an entirely new model that runs Calendar Months/Years in the TimeConfig. Then created a module in there and did as @ManjunathKN did. Then import the results from this module into your 4-4-5 calendar (or which ever one you use).

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