Need help passing business rule into scenario member filter of Cube View.
I have a cube view with 12 columns (one for each month). It is used in a quarterly activity, and the columns need to reflect the appropriate forecast scenario depending on which workflow was opened. (e.g. in June 2026, the cube view would have the 6+6 Forecast for Jul thru Dec). I've created the below BR to determine each forecast should be used, but now I'm unsure what I need to enter into the cube view scenario member filter for the columns to use this BR: Public Function OCF_FcstScenarioSelect(ByVal si As SessionInfo, ByVal api As Object, ByVal args As FinanceRulesArgs) As Object Try ' Workflow POV time (from workflow context) Dim wfTime As String = api.Workflow.Time.Name Dim wfPos As Integer = wfTime.IndexOf("M"c) Dim wfYear As Integer = CInt(wfTime.Substring(0, wfPos)) Dim wfMonth As Integer = CInt(wfTime.Substring(wfPos + 1)) ' Column POV time (from cube view) Dim colTime As String = api.Pov.Time.Name Dim colPos As Integer = colTime.IndexOf("M"c) Dim colYear As Integer = CInt(colTime.Substring(0, colPos)) Dim colMonth As Integer = CInt(colTime.Substring(colPos + 1)) Dim scen As String ' Determine scenario per column If (colYear < wfYear) OrElse (colYear = wfYear AndAlso colMonth <= wfMonth) Then scen = "ActBud" Else Select Case wfMonth Case 3 : scen = "Forecast_3_9" Case 6 : scen = "Forecast_6_6" Case 9 : scen = "Forecast_9_3" Case Else : scen = "ActBud" End Select End If Return scen Catch ex As Exception Throw ErrorHandler.LogWrite(si, New Exception("Error in OCF_FcstScenarioSelect: " & ex.Message)) End Try End Function I would appreciate any help, as I'm new to using BR's for this purpose, and I have been unsuccessful in finding a solution to my specific issue via search engines. Thanks in advance!
Cannot save same value from parameter twice in SQL Table Editor
I have created an SQL table editor component for one of my applications. One of the columns in the SQL table can be updated by the user, and is tied to a parameter that is used as a dropdown by the users. However, if the user tries to update that column in two rows to the same value only the first row will be saved, but if the two rows are populated with different values from the linked parameter the table is saved just fine. Has anyone else experienced this? Has anyone discovered a workaround? Thanks, Tom R
Unable to open shared Cube View
Hello, We are trying to use row and column templates in a Cube View but are using parameters to populate the names of those row and column template cube views. We get the below error and are curious what else could be issue as we have checked values of parameters and they are pulling in values expected (names of templates). Thanks!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?PowerBI Custom Data Adapter
I have built a OS data adapter off of a cube view that has a parameter that prompts for entity. I subsequently built PowerBI query to pull data via this data adapter. I can get the PowerBI query to pull data if I hardcode the Entity parameter value in the Custom Subst Vars in PowerBI. What I would like to do is replace hardcoding the Entity value with list prompt for the user. That will let the user decide which entity they want to pull when they refresh the query. Any ideas on how to create this functionality? #PowerBI
Create new Documents in Narrative Reporting
Hi, I am attempting to upload files for our Narrative reporting and I am failing miserably here... I would like a CubeView report in either Microsoft Word or PowerPoint. I have following the instructions online within Word to Insert >> Field >> DocVariable and input the Syntax as instructed: I add it to my Narrative files and keep getting errors about parameters. I went as far to change the report so there are no parameters and all the dimensions are defined within the CubeView. Any ideas what I could be missing? Or does anyone have an example of what they used for their syntax and uploads? I can't seem to find this initial step.
