Map source account to target account member and Ud4 member
Hi Everyone, I have a source file which contains multiple accounts in the columns for one month. These accounts are not there in the cube. I do not have a ud4 dimension in the source file. Each source account should be mapped to an account and Ud4 member. for ex: Account a001 has to be mapped to account A#a1 and Ud4#cost. Similarly Account b001 has to be mapped to account b#b1 and Ud4#sale. A#[a001]=A#[a1]:UD4#[cost] A#[b001]=A#[b1]:UD4#[sale] How can this be achieved in the transformation rule. Also, the data source needs to have ud4 or not. Thanks, Jeevan
How to get cell context?
This is the layout of my CV I'm using an XFBR in rows (and columns); the rules for each scenario are different; how do I get the context from the columns? In other words, when the scenario is Budget I want to apply specific rules for that scenario, same thing for Actual. This would be the script: Namespace Workspace.__WsNamespacePrefix.__WsAssemblyName.BusinessRule.DashboardStringFunction.REP_ParamHelper Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As Object Try If args.FunctionName.XFEqualsIgnoreCase("GetAccount") Then //Do something End If End Function End Class End Namespace
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
