Rolling data snapshots of Weekly and Monthly forecast for different Versions

We have a scenario where there is a need to do a weekly forecast for short term (next 13 weeks) and monthly forecast for remaining periods of the fiscal year. The forecast and actuals need to be captured in both weekly view and monthly view. Also the monthly view needs to be tied to a consolidation system (another tool having data at monthly level fiscal periods).

There are many entities and the fiscal calendar is not same for all of them. Majority follow the Gregorian calendar but there are several entities having different starting and ending dates for each fiscal periods. For Ex.

Entity 1 = Period 1, Jan 21, 1st Jan to 31st Jan

Entity 2 = Period 1, Jan 21, 1st Jan to 28th Jan

Entity 3 = Period 1, Jan 21, 1st Jan to 4th Feb

Since this can't be accommodated within the Model calendar due to different dates for fiscal period and the weeks not rolling to specific periods, an option is to have the native calendar set to "Months/Quarter/Years" to get the monthly view and creating a custom weekly list to get the weekly view.

The entity dimension is very big (3000+) and other dimension being used in different modules includes currency type, customers, vendors, channels, time, versions and will result in large sized modules.

Additionally there is a requirement to snapshot the forecast into different versions and use them for variance analysis within Anaplan. So the current forecast needs to be saved into the following snapshots for all key modules and also require variance analysis between them. The Prior 1 to Prior 4 are rolling snapshots and needs to be updated as week changes.

Forecast - WK1 : Snapshot at the start of current quarter
Forecast - Prior 1 : Snapshot 1 Week Ago
Forecast - Prior 2 : Snapshot 2 Week Ago
Forecast - Prior 3 : Snapshot 2 Week Ago
Forecast - Prior 4 : Snapshot 5 Week Ago

Any suggestions on the best approach to achieve the weekly and monthly views and also the efficient way to manage the snapshots?

Accepted answers

All comments

ArunManickam

Rolling forecast can be achieved using a process.

Import Current forecast into Prior-1

Prior-1 into Prior-2

...

Prior3 into Prior-4

Thanks

Arun

ChrisAHeathcote

@gaurav

The simplest approach to preserve prior forecasts is to utilise the bulk copy functionality.

This will allow you to create and copy the current forecast into a new forecast version.

However, this action will significantly increase the size of the model if you continue the process for the whole 14 weeks.

You will also need to map each calendar into a standard model calendar so that you can compare across entities, mapping days into weeks and weeks into months/periods.

Your model will be huge and from your requirements this is unavoidable if you want to retain 14+ different forecasts, plan at both weeks and months along with using a variety of different calendars.

My advise in this regard is question why you need to retain so many forecasts when Anaplan's strengths come from the ability to plan into the future not reporting past events. Do you really need this amount of data to achieve this?

Good luck,

Chris

gaurav

@ArunManickam

We can do that but there are many modules and we will have size constraint. please suggest the best approach considering model size constraint.

Gaurav

gaurav

@ChrisAHeathcote

Yes, Model size is the main issue. Customer wants to have the snapshot for previous weeks as well to check the variance and there are many modules so model size is the biggest concern.

Gaurav

rob_marshall

@gaurav

We see this problem quite a bit and my suggestion is to work backwards to forwards, meaning from reporting requirements to development of modules and logic. I say this because from the beginning, you stated it will be many modules needing these versions and snapshots, but is that really the case? I would suggest understanding what the true requirements are for reporting and variance analysis and then define the modules/logic for that. When you do this, you very well may need a few modules with all of these versions, but not likely for all of them from a reporting perspective. Also, another idea, you might want to consider mixing native versions (for input) with a custom version list used for reporting. You may already know this, but bulk copy can be used on any list, not just native versions.

Hope this helps,

Rob

andrewtye

You might find this https://community.anaplan.com/t5/Best-Practices/Modeling-Best-Practices-Video-Series-1-Flexible-Time-Mapping/ta-p/93234 helpful particularly around the rolling weeks piece.

zach_hird

@rob_marshall

Can you elaborate further on "bulk copy can be used on any list, not just native versions."

Thanks

rob_marshall

@zach_hird

Absolutely...Just because people go to Versions to "get" to the Bulk Copy, it can actually be used on any list. Take a look.

Hope that helps,

Rob

zach_hird

@rob_marshall

Thank you very helpful! Have you seen a good solution for taking monthly forecast snapshots and not letting the data change in those snapshots?

I thought versions and bulk copy would do it, but if a switchover date is included in the snapshot version then actuals could technically change for any line item using "if isactualversion()..." before the switchover date. And if a switchover date isn't used in the snapshot version then actuals data will never get to line items that use "if isactualversion()..." because the system doesn't know when actuals start/stop (even after a bulk copy from actuals to snapshot version A). I'm torn.

Basically I'm looking to freeze/ snapshot data (actuals and forecast) and never have that data change but also be able to refer to these snapshots for variance and other reporting

rob_marshall

@zach_hird

Snapshotting is always fun. First, I would understand what actually needs to be snapshotted and why? Does it have to be the most granular data or can it be summarized/aggregated up? If the answer is the most granular level, then why? What will it be used for? Is it a nice to have for a report or is it a must have? What type of reports will you be using the snapshots for? Will they be for variance reporting between Actuals and a snapshot or will it be just between snapshots? How many modules are we talking about that need to be snapshotted or is it just one module? Lot's of questions that need to be answered in order to answer the question.

With that said, I would lean towards a custom list for the snapshots and populate it via actions. That way, you don't have to worry about switchover.

Hope this helps,

Rob

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…
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.…