Can some one explain the SWITCHOVER concept with suitable example !!

When ever I try working with the switchover concept in versions..in merging and making the forecast with the actual ...though I get resuls , still my mind pops up with questions about this. Hence I request some one in clearing my doubt please.Tq

Accepted answers

All comments

ChrisAHeathcote

@keerthipatiaditya

Switchover is the time period from which the actual version switchesover to the version being displayed.

For example, the forecast version has a switchover date of Jun 21.

When switchover is enabled when the forecast version is selected actual version data will show up to the Apr 21 and from Jun 21 data will switchover to the selected forecast version.

Hope this helps.

GONI

Hi,

When Switchover is enabled then the Anaplan will merge Actual data with forecast data.

Here is the example. Considering Switchover date is May

	Switchover	Jan	Feb	March	April	May
Actual		1	2	3	4	5
Forecast	Before	11	22	33	44	55
Forecast	After	1	2	3	4	55

Hope it helps!!

Regards,

Basavaraj Goni

yashbhadoria

Hi Basavaraj

We are getting actual data in place of forecast data in forecast for switchover of may. But forecast for may is not changing based upon the actual data. Then what is the purpose of switchover when forecast remains the same??

If it is for conversion of forecast data into actual data then, in what scenario we use this switchover functionality?

Please help me in understanding above questions. @ChrisAHeathcote , @JaredDolich

Regards

Yash

JaredDolich

@yashbhadoria

Good question. Most likely the line item hasn't been enabled for switchover. Scroll to the right on the line item and you will see a checkbox that turns it on. Another suggestions is to make sure you are using the native versions in your module. TBH, I don't use native versions that often because of the challenges updating the switchover period from outside of Anaplan.

@GONI is right though. It's used to automatically copy actuals into your forecast. For example, Here I have turned on breakback and set it to week 5.

I then enable the line item for breakback and now you can see the first 4 weeks of forecast are no longer editable.

CommunityMember111277

@JaredDolich @ChrisAHeathcote

One quick question about Switchover -

Let say I have selected switchover as May'22 - the below table reflect the correct outcome.

However, let say my forecast value should also change for the remaining months basis on Actuals, then how will I manage that with switchover

Current Forecast - 1000 for each month
Actuals till April - 4300
So, basis on Actuals, I want the forecast to change from 1000 to 1075 (Average of 4300)
Again, once I input Actuals for May, again my forecast will change based on Actual's Average, how will I manage that with switchover

Thanks

JaredDolich

Great question @CommunityMember111277

I have two possibilities you might consider, one with switchover the other without.

If you are determined to use switchover, then two ways you can handle is to use an action that takes a percentage difference (from a driver) and applies it only to the remaining weeks (unelapsed weeks). You'll need a Boolean filter for your saved view that filters out the elapsed weeks.
The better option, in my opinion, is to not use switchover. But rather use time system module that keeps track of the current month. From there you can use native versions if you like or a IF/THEN conditional to choose one value over another depending on the current period. You also have the option then of using the solution above or add the logic to override the forecasts with a percentage. Lastly, and this is how I do it, I use breakback and dynamic cell access to control which values are editable. If the period is elapsed, it's uneditable. If unelapsed, it's editable. Then breakback will only be applied to the editable values.

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!