Multiple Model Builders changing Actuals Through Switchover

Hi everyone -

We have a large team of builders and one of the most used modules is pulling Actuals Through from the Lookup Reference module. It can be frustrating when Actuals Through Switchover dates keep changing due to people working on different things.

Has anyone found a workaround or have a suggestion for best practices when working with a large team of builders? For example, separate actuals through switchovers for each person? Or an app page that has actuals through switch over but doesn't impact the related module? Thanks for any insight!

Accepted answers

All comments

ManjunathKN

Hi @brigette

It is not possible to have different switchovers to different people for same version. Can you give some insights on how the actuals date change for different team, ideally, it should be only same across all places.

If some teams are forecasting on different time periods then, you should use different versions for facilitating different switchover. Custom versioning with System module which acts like switchover will be some options here.

Thanks,
Manjunath

brigette

Thanks for the insight. During quarter end, we use the P&L modules for reporting purposes (actuals through a quarter end date) and use it for creating a new forecast (actuals through current date). The P&L module is not tied to actuals through for the specific version, it is a separate line item in the lookup reference so we can show the rolling forecast as actuals come in.

We thought about creating a duplicate module just for reporting purposes and having the actuals tie to the version. However, the module is very large, so we wanted to see if there are other alternatives before taking this route.

ManjunathKN

@brigette

Okay! So if you want to create a new forecast basis on current date actuals , which is actually derived from your quarter end actuals.

I believe 2 custom versions should suffice(I dont prefer native versioning for this) And I think you have to do lookup only for current date actuals based forecast (to keep it rolling) and quarter end actuals should be formula based on your current date actuals(previous(quarter)).

Let me know if this helps in anyway.

Thanks,

Manjunath

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.…