Beginning Balance Formula
Our beginning balance formula is as follows: 'Check to see if we are in period 1 If api.Time.IsFirstPeriodInYear() Then ......... Else ............... This formula worked perfectly rolling from 2023 into 2024, but now in 2025 we are having issues. EX: In Feb 2025, the beginning balance is reverting back to Dec 24 instead of Jan 25. Any insight into where I might start in figuring out this error? I tried looking at our business rules for api.time and didn't see anything that stood out. Thanks!
SaveCustomDataTable Gives Error
I want to load OneStream application data to external database. And there is an existing connection to the target external database. But it gives me below error, could you please help? No idea what is wrong. BTW, "FDH_DEV" is SIC external database connection. 'Build a data table with one test line Dim TestTbl As New DataTable TestTbl.Columns.Add("Tmt", Type.GetType("System.String")) TestTbl.Columns.Add("SEnt", Type.GetType("System.String")) TestTbl.Columns.Add("TEnt", Type.GetType("System.String")) TestTbl.Columns.Add("SAct", Type.GetType("System.String")) TestTbl.Columns.Add("SActD", Type.GetType("System.String")) TestTbl.Columns.Add("TAct", Type.GetType("System.String")) TestTbl.Columns.Add("TActD", Type.GetType("System.String")) TestTbl.Columns.Add("SFlw", Type.GetType("System.String")) TestTbl.Columns.Add("TFlw", Type.GetType("System.String")) TestTbl.Columns.Add("SIc", Type.GetType("System.String")) TestTbl.Columns.Add("TIc", Type.GetType("System.String")) TestTbl.Columns.Add("SU1", Type.GetType("System.String")) TestTbl.Columns.Add("TU1", Type.GetType("System.String")) TestTbl.Columns.Add("SU2", Type.GetType("System.String")) TestTbl.Columns.Add("TU2", Type.GetType("System.String")) TestTbl.Columns.Add("SU3", Type.GetType("System.String")) TestTbl.Columns.Add("TU3", Type.GetType("System.String")) TestTbl.Columns.Add("SU4", Type.GetType("System.String")) TestTbl.Columns.Add("TU4", Type.GetType("System.String")) TestTbl.Columns.Add("SU5", Type.GetType("System.String")) TestTbl.Columns.Add("TU5", Type.GetType("System.String")) TestTbl.Columns.Add("SU6", Type.GetType("System.String")) TestTbl.Columns.Add("TU6", Type.GetType("System.String")) TestTbl.Columns.Add("SU7", Type.GetType("System.String")) TestTbl.Columns.Add("TU7", Type.GetType("System.String")) TestTbl.Columns.Add("SU8", Type.GetType("System.String")) TestTbl.Columns.Add("TU8", Type.GetType("System.String")) TestTbl.Columns.Add("SAmt", Type.GetType("System.Decimal")) TestTbl.Columns.Add("TAmt", Type.GetType("System.Decimal")) TestTbl.Rows.Add("Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test","Test",100,100) BRApi.Database.SaveCustomDataTable(si, "FDH_DEV", "ods.ONESTREAM_EXTRACT_Src2TgtDashboard", TestTbl, True)Weekly scenario - Use scenario start/end period settings
Hi community, For one of our clients we are looking for the following. - We create 52 weekly scenario with each their own start and end period setting in the workflow start time and workflow end time. For example we have the scenario CFF_2022W01 which has a workflow start time as 2022W1 and a workflow end time as 2022 W39. For example the scenario CFF_2022W02 which has a workflow start time as 2022W2 and a workflow end time as 2022 W39 etc. How can we get a list of members of the range within the start and end time in the scenario. So for example based on the CFF_2022W01 scenario it should return in the list 2022W1, 2022W2 up until 2022W39. For CFF_2022W02 it should return in a list 2022W2, 2022W3 up until 2022W39. There is also the example when the periods run across years. So for example the scenario CFF_2022W27 has a workflow start time of 2022W27 and end time of 2023W13. The list should then return 2022W27, 2022W28 up until 2022W52 plus also 2023W1 up until 2023W13. This is what I used so far but is not working correctly for weeks. --- Dim instance As New BRApiFinanceScenario() Dim ScenarioStartPeriod As Integer = instance.GetWorkflowStartTime(si, ScenarioId) Dim ScenarioEndPeriod As Integer = instance.GetWorkflowEndTime(si, ScenarioId) Dim noOfNoInput As Integer = instance.GetWorkflowNumNoInputTimePeriods(si, ScenarioId) Dim ScenarioPeriods As List(Of Integer) = TimeDimHelper.GetIdsInRange(ScenarioStartPeriod, ScenarioEndPeriod) 'Removes all periods up until the input range ScenarioPeriods.RemoveRange(0, noOfNoInput) ----- Has anyone come across using these settings and what syntax should be used.
copying quarterly inputted data into Monthly scenario
Hi, want to copy quarterly input data through business rule. the destination scenario is defined as monthly input. in the destination code , i want to specify months which system doesn't allow. we need pass in DM Job. As i have several quarters to copy , can anybody share some thoughts how we can achieve this. Thanks, Swadhin.
How to move an entity member to a new parent with nocache
Hi Folks, Can anyone give me an example of moving an entity from one parent to another using ReadRelationshipNoCache? Or even the version using GetRelationshipInfo? CopyOrMoveRelationships doesn't have a 'no cache' option, so looking to do it at a lower level by reading and updating the member's relationships (i.e. dropping one and adding another) -Jon
Is it possible to setData using SaveDataEventHandler?
Hi everyone, We’ve been using the SaveDataEventHandler to prevent users from submitting zero values for a specific scenario and flow. While the error message works perfectly in the Cube Views, we’ve encountered an issue when users try to submit a zero from Excel—no error message is displayed. From what I’ve read, error messages don’t work in Excel. As a workaround, we’re considering a different approach: instead of throwing an error when a zero is submitted, we would save the zero as NotStored (dataCellStorageType.NotStored) and NoData (dataCellExistenceType.NoData). However, despite our efforts, we can’t get SaveData to function as expected. Has anyone encountered this issue or have any ideas? Dim ScenarioName As String = "Actual" Dim FlowMember As String = "USDOverrideEndBal" If args.NewDataCell.DataCellPK.ScenarioId = BRApi.Finance.Members.GetMemberId(si, dimtype.Scenario.Id, ScenarioName) Then If args.NewDataCell.DataCellPK.FlowId = BRApi.Finance.Members.GetMemberId(si, dimtype.Flow.Id, FlowMember) Then If args.NewDataCell.DataCellPK.OriginId = DimConstants.Forms Then 'Check if it's Real Data If args.NewDataCell.CellStatus.IsRealData Then 'Check if it's a hard zero If args.NewDataCell.CellAmount = 0 Then Dim NewNumber As Decimal = 0 args.NewDataCell.SetData(NewNumber, dataCellExistenceType.NoData, dataCellStorageType.NotStored) End If End If End If End If End If Return args Thanks, Victor
Calculated data disappeared after importing zip file with XMLs
Hi everyone, In my environment, I had some calculated data in 2023Q4. 2023Q4 was completely locked and certified. After that, I loaded a zipfile, containing XMLs consisting of Cube Views, Data Management Steps, Extensibility Rules, Metadata and some dashboards. I uploaded this to update an existing partnerplace solution running in my application. After loading the zip file, the calculated data from 2023Q4 was gone. After recalculating, the data was back, so no issue. However, I'm very confused on how the load of a zip file containing XMLs could have affected calculated data in a locked period. Thanks for any help or information. Kind regards, Floris
