The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Creating a Prior Year Scenario
Hi -
How do I create a scenario for prior year? I'm building a flux report (variance analysis) where I can compare data between different scenarios (e.g. Actual v. F9).
I was suggested to create this member in U8, and input a dynamic formula. However I am not sure what the code should be. If this is a route I should pursue, please advice.
Any ideas will be appreciated.
Thank you!
4 Replies
EricOsmanskiOneStream Employee
If you are just trying to view PY data of a scenario, you shouldn't need a new scenario. There are variables to retrieve prior year, such as |WFYearPrior|, |POVYearPrior|, |CVYearPrior|, etc, etc. It'll depend on how the CV is setup.
This is how I've setup my columns. Created two parameters (Scenario 1 & 2) which consists of all the scenarios.
on the rows, I have accounts
- EricOsmanski
Ok - and what exactly are you trying to do?
ChristianWHi
The delimited list doesn't need to be one dimension only, you can easily combine it:
Display Item: None, Actual, Budget, [Actual previous year},F1,...
Value Item: S#None, S#Actual, S#Budget, S#Actual:T#|CVYearPrior|, F1...
