How to convert Date to 445 calendar week

Hi All,

The requirement from the client is that they will upload the sales history for an SKU by date into Anaplan. Hence there will be 3 columns SKU, Date, Quantity. The model calendar is set as 445 calendar and the end of fiscal year is last Sunday. The problem is I want to convert this flat upload so that I can aggregate the data in a module which has a dimension of SKU and Model timescale with line item as Qty.

I am stuck at a point where I am unable to convert date to 445 week format. Please suggest a way to handle this problem.

Gaurav

Accepted answers

rob_marshall

@GauravT ,

If you model is set to 445 (or any other time frame) and you are importing at the day level, Anaplan is smart enough and will understand what weekly bucket to aggregate the data so you will not have to store it at the daily level. To do this, your landing module is dimensionalized by Time, but the weekly format. In the action, you are still doing the same mapping, but upon load, Anaplan will automatically aggregate the data for you. Ideally, if you are not using daily data but that is what you have been given, there is no reason to store daily data within Anaplan. Let Anaplan do the heavy lifting for you.

Does this help?

Rob

All comments

VIGNESH.M

Hi,

Aggregate the qty using SUM function

Create a module, Dimensions(SKU, Time(Week Format), line item - QTY)

QTY = Staging Module.QTY[Sum:SKU,SUM:DATE]

You don't have to convert date into week format, directly sum by date, if you still want week format, create a line item with week format, logic is period(Date).

Regards,

Vignesh M

rob_marshall

@GauravT ,

Does this help?

Rob

Misbah

@GauravT

Hi Gaurav,

Anaplan is smart enough to convert the numbers from dates to weeks based on the time settings that you would have used for the model.

@vignesh has explained it how to do it.

Thanks,

Miz

Quick Links

Can you help?

Unanswered questions

I attempted the Anaplan Level 2 Model Building - On Demand Sprint 1 exam many times due to system i
I attempted the Anaplan Level 2 Model Building - On Demand Sprint 1 exam many times due to system issues and Sprint 1 exam got locked. Can you please support to resolve this issue soon as I need to resume doing my Sprint 1 exam and next lessons.
Anaplan Matillion Integration
I have a requirement to extract last 90 days data from an Anaplan model through Matillion. I wanted to know is there any API which I can use to achieve the same? I have taken a look at the (Integration APIs) Bulk API as well as Transactional API and none of them has a relevant query parameter which I can use to apply the…
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?