Sum Weeks to Months based on date of WeekMonday

Hello everyone!

I am desperately trying to map which weeks go into which months, based on the date of the monday. The monday should hence decide the month for which the given weeks data should be allocated in full.

Please see enclosed image (see "ISOWeekMondayMonths"), where I have managed to have the system automatically help me assign the right months to the given weeks. Problem is I am not sure how to reposition and utilize it to calculate the wished for monthtotals in the data/calculation-module (see "MonthTotals.png")

I want to avoid anything that relates to "Fake weeks, months" etc. and instead solve it through mapping or similar.

Found some previous posts that are somewhat close to this challenge, but I have not been able to solve it despite their helpful content - maybe a sharper Anaplanner can help me adjust the solution to the issue I am facing?

https://community.anaplan.com/t5/Anaplan-Platform/SUM-weeks-into-Months/m-p/122257#M30691
https://community.anaplan.com/t5/Anaplan-Platform/Custom-Time-Aggregation/m-p/109592#M26403

https://community.anaplan.com/t5/Anaplan-Platform/Map-Result-from-System-Time-Days-to-Customer-Days-Fake-Days/td-p/110331

https://community.anaplan.com/t5/Anaplan-Platform/Find-5-Saturdays-in-a-month-using-Date-functions-and-not/td-p/43305

@ChrisAHeathcote @rob_marshall (tagging you lads in the hope that you might be able to support as you have been incredibly helpful in the linked to threads)

Thanks in advance )

MonthTotals_152891.png

ISOWeekMondayMonths_152891.png

Accepted answers

StevenBeerthuizen

Your SYSBB module has FY20 dates in it. But by now you have solved that I guess. Anyway, you keep on having issues adding up the data in a decent month overview, because the Anaplan engine will just add it up in the native way. If you don't need the months anymore later on then there is of course no issue. KR, Steven

All comments

StevenBeerthuizen

Guess that's impossible without "fake" time dimensions. I read a comment from David Smith once that it had to do with the design of the hyperblock. Anyway, time won't roll up based on a mapping, but by the default blocks.

KR,

Steven

SirValdemar

Hey Steven,

Thank you for responding. Would it not be possible to avoid fake time list by doing something similar to what Rob suggested in this thread? https://community.anaplan.com/t5/Anaplan-Platform/Custom-Time-Aggregation/m-p/109592#M26403

So if I can get Anaplan to automatically put the right start week and end week to each month, then I could use the same solution which Rob suggested with days/dates?

SirValdemar

Like the enclosed picture where I have attempted to implement what Rob suggested, but with weeks instead of days. However I do not get the results I hoped for. Must be missing something! 🙂

A1_152905.png

StevenBeerthuizen

SirValdemar

Thanks Steven,

Guess I have stared at it for too long to even notice! For this solution to work I need fully automate it however but need to be able to find a solution to this last challenge I have enclosed a picture of below. You wouldn't have to have an idea on how I could get the right min-max weeks into those monthly cells by any chance?? 🙂

WeekTrixing_152920.png

MatthewSweere

@SirValdemar I have a very similar ask to your initial question. Were you able to find a workable solution? If so, would you mind sharing it?

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…