Forum Discussion

SHerbst's avatar
SHerbst
New Contributor
2 days ago

Scenario management for FX

We are in the design and build phases of OneStream and it is really important to me that we get the foundation right and use OneStream the way it was intended to be used.  What are the recommended design solutions in OneStream to enable users to quantify the FX translation impact separate from performance when comparing one period of time to another (e.g., YTD actuals versus budget or full year latest forecast versus full year budget).  Hi HFM we do this through recalculation scenarios.  For example, we have the following budget and forecast scenarios.

  • 14 forecast scenarios - one for each month, one to recalculate the prior forecast at the most recent actual rates (used for comparisons against YTD and month actuals), one to recalculate prior forecast at the forecast rates (used for full year comparisons to prior forecast and full year budget).  The latter two get overwritten every month with the latest previous forecast data and new rates.
  • 3 budget scenarios - one for the original budget, one to recalculate the budget at the most recent actual rates, one to recalculate at the latest forecast rates.  The latter two get overwritten every month with the new rates.

The process works well in HFM.  Should we design the same solution in OneStream?  How do other people manage this?

No RepliesBe the first to reply