Skip to main content
Question

Locking Data for Budget Purpose

  • December 20, 2025
  • 3 replies
  • 58 views

Forum|alt.badge.img+2

Hello All, 

I’m currently trying to build a budget for the next year and running into issues on how to lock data down.

Example: Set up a budget for FY26
Current Date: 12/19/25
Current Month = Dec 2025
Latest Actual Month (Switchover Month) = Nov 2025

OpEx Planning: I will set the switchover month as Nov 2025, so the data is locked down already.

Headcount Planning: Our headcount roster is being loaded on a daily basis and overwritten until the last day of each month so our most up to date data is 12/19/25.

Let’s say I want to say today is the day I want my budget to be set and won’t change after 12/19/25. I can create a scenario based on my current scenario which locks down the data for OpEx but my headcount data will essentially be still moving because by tomorrow, it would be using a new transaction list on 12/20/25.

I’ve thought of few proposals to resolve this issue but each has its own flaws so I would like to know the best practice to lock down the data.

Proposal 1: Use Headcount data as of Nov 2025
This method ensures my numbers won’t change because all data is fixed already but I lose the potential of using the most updated data when I set budget for 2026.

Proposal 2: Creating a snapshot
This method ensures my numbers won’t change but defeats the point of creating a Budget scenario because the snapshot will not align with the scenario. And the snapshot is less flexible than using scenarios.

Proposal 3: Stop importing headcount data until the next month
This method ensures my numbers won’t change but I’m also able to use the most current data for my forecast. The issue for this is Workday imports have to be scheduled on a cadence and this method would need manual uploads.

Thank you!
 

3 replies

Laszlo
Master Helper
Forum|alt.badge.img+8
  • Master Helper
  • December 23, 2025

Hi ​@Kelvin Chan ,

 

Because you overwrite your transaction list every day with a new import, your app doesn’t retain historical data that could selectively feed a scenario or version.

To achieve your goal without the drawbacks you mentioned, I see two options:

  • by implementing incremental data loading and then tie each scenario/version to a particular data load (automatically to the last data load by formula, with the option to manually override - thereby allowing locking your source data to the data load from a particular day) 
  • or by building a data staging mechanism, which gives you full control over the source data for your calculations. This allows you to take a snapshot of the source data manually (as and when required) and store it in a metric, which will then serve as the source for your calculations. However, this approach may be inconvenient due to its manual nature.

Cheers,

Laszlo


Forum|alt.badge.img+2
  • Author
  • Author
  • December 23, 2025

Hi ​@Kelvin Chan ,

 

Because you overwrite your transaction list every day with a new import, your app doesn’t retain historical data that could selectively feed a scenario or version.

To achieve your goal without the drawbacks you mentioned, I see two options:

  • by implementing incremental data loading and then tie each scenario/version to a particular data load (automatically to the last data load by formula, with the option to manually override - thereby allowing locking your source data to the data load from a particular day) 
  • or by building a data staging mechanism, which gives you full control over the source data for your calculations. This allows you to take a snapshot of the source data manually (as and when required) and store it in a metric, which will then serve as the source for your calculations. However, this approach may be inconvenient due to its manual nature.

Cheers,

Laszlo

I noticed there’s a new functionality called “Data Slices” which allows you to select a snapshot as data source. Would this be a useful if I replace my scenarios using this data slice functionality?


Laszlo
Master Helper
Forum|alt.badge.img+8
  • Master Helper
  • December 24, 2025

The Data Slices is a comparison function, and you can indeed add a snapshot as a source of slice(s). However, a snapshot is a static set of data as captured at the time the snapshot was created, and it will not reflect changes in your live model setup, such as updates to drivers or formula changes. It might still work for your use case, so it could be worth exploring. 

Simplify Version Comparisons with Data Slices

Compare Data with Data Slices