Switchover, use it or build your own?

Options
jbrass
jbrass Member, ALL USERS, Community Member Posts: 5 Frequent Contributor

Hi All - 

 

In the context of an FP&A use case, we're trying to evaluate whether to use switchover or just build a system module to dictate where the forecast begins and the actuals end.  Would love to hear about pros and cons of both approaches.  Here's what I have so far:

 

Pros of using native switchover:

1) Ability to use formula scope, thereby allowing for a formula to work for actuals and then allow for direct data input for forecasted months.

 

Cons of using native switchover:

1) Potential for reducing size of model by removing "Actual" version altogether.

 

Any more insight/preferences/best practices would be appreciated here.

 

Thank you!

Josh

Tagged:

Comments

  • jbrass
    jbrass Member, ALL USERS, Community Member Posts: 5 Frequent Contributor

    Thanks Rob.  Very helpful.  The initial consideration was to still use versions but just not use switchover, however you bring up a good point: maybe we shouldn't use versions at all.  I think it comes down to how much we value the ability to use version subsets.  Appreciate the insight.

     

    -Josh

  • jbrass
    jbrass Member, ALL USERS, Community Member Posts: 5 Frequent Contributor

    True that you are restricted to one set of actuals using switchover.  Makes sense.  Thanks Andrew