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
Manjunathak
2 years agoNew Contributor III
Workflow profile - Calculation Defination
Workflow form has different scenarios Actual, forecast.
I have created the step for Force Consolidate and Scenario Type filter is set to (ALL).
when i complete the form only Actual Scenari...
- 2 years ago
I may be the exhausting week talking and I hope I am not missing anything here, but I am fairly certain that the Process definition calculates your WF POV scenario. Which in your case is Actual, which is why Forecast (LY) does not get calculated as it is not in the WF POV.
There are other ways to trigger the LY calculation such as dashboard buttons, data management jobs, or NoCalculate steps with a workflow event handler. Or you change the scenario in your WF POV to LY and Process it there.
Manjunathak
2 years agoNew Contributor III
workflow scenario is Actual
the form is available only in Actual scenario but i have the entity assigned to forecast scenario also.
First column in form has Actual data and other columns has forecast scenario data, want to compare the Actual numbers with forecast. i need to consolidate each column separately to have numbers that's reason i'm looking for calculation definition step to consolidate for both actual and forecast scenarios
Henning
OneStream Employee
2 years agoI may be the exhausting week talking and I hope I am not missing anything here, but I am fairly certain that the Process definition calculates your WF POV scenario. Which in your case is Actual, which is why Forecast (LY) does not get calculated as it is not in the WF POV.
There are other ways to trigger the LY calculation such as dashboard buttons, data management jobs, or NoCalculate steps with a workflow event handler. Or you change the scenario in your WF POV to LY and Process it there.
Related Content
- 1 year ago
- 8 months ago
- 2 years ago