Rules

Do we have any way of restricting the Unbalanced Journals in OneStream? I read about the Journal Event Handler but don't see that BR in my application. 

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.

I am writing a simple api.data.calculate code in C#. Somehow it is not able to recognize Durable data "true" but it does work vb.    

Hi,I need to use inside my Table View service some parameters that are bound to combo boxes in order to write a query, and execute it when the "SaveTableView" function is called. Unlike the "GetTableView" function, SaveTableView's signature doesn't provide a parameter that contains all substitution variables (Dictionary<string, string> customSubstVars for GetTableView)I also tried setting the customSubstVars dictionary into the BRGlobals from the GetTableView function, but once you try getting the dictionary from the globals, it returns null.Is there no way of getting this customSubstVars dictionary to use it inside SaveTableView?

Hi, I was wondering if anyone knew how to get an extracted list of all artifacts within an environment by artifact types such as business rules, transformation rules, cube view names. I am only interested in getting the names/metadata of each artifact and not the actual data from the artifact. I would like to put these in an excel workbook.  Thanks! Manuel

Hi OS Community,Hope you are doing well!Out of curiosity, I wanted to check which approach is more efficient for clearing data: using api.data.clearcalculateddata or clearing combinations using databuffer?Few examples would be really helpful.Thank you!

am trying to create a confirmation rule, to balance the balance, however when compiling the rule I get an error, in another version the rule was broken and no error is shown, any recommendations?

Hello OS CommunityI am trying to compile a BR associated with a transformation rule, but it shows me the following error:Do you know how to resolve this issue?

I have a dashboard where I created Parameter1 using bound list which is referenced in a combo box. A button then passes the data to the business rule. The issue I am having is that it only recognizes the first selected member and ignores all other selected members. How do you pass a multiselect list from combo box in Dashboard in order to loop through the list?

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

Hello OS Community - We are in process of testing 8.5 version upgrade and running into below error on one of the BR, looking for solution any help is appreciated. Error at line 963:  Overload resolution failed because no accessible 'GetMemberInfo' is most specific for these arguments:    'Public Overloads Function GetMemberInfo(si As SessionInfo, dimTypeId As Integer, memberName As String, [includeProperties As Boolean = False], [dimDisplayOptions As DimDisplayOptions = Nothing], [memberDisplayOptions As MemberDisplayOptions = Nothing]) As MemberInfo': Not most specific.    'Public Overloads Function GetMemberInfo(si As SessionInfo, dimTypeId As Integer, dimNameOrEmpty As String, includeInheritedDims As Boolean, memberName As String, [includeProperties As Boolean = False], [dimDisplayOptions As DimDisplayOptions = Nothing], [memberDisplayOptions As MemberDisplayOptions = Nothing]) As MemberInfo': Not most specific.  

Hello OS CommunityI am trying to execute the "Run Confirmation" from a Workflow view:But it shows me the following error: Do you know how to resolve this issue?

Hi, I am trying to call Table view service from a spreadsheet. I tried to use the syntax defined in the reference manual. The above syntax is not working. The above syntax works with the Spreadsheet Business Rule Assembly. Anyone tried Table view service type? If so, what is the syntax to call the table view service from a Spreadsheet?  

What is the default state of IsDurableCalculatedData if left out of an api.data.calculate statement?  I'm assuming it's false but I just want to double check.I'm seeing an api.data.calculate statement which contains an "onEval" statement, then a comma, then False.  If I look at Intellisense, the first field after the "onEval" is userState, followed by the Boolean for IsDurableCalculatedData.  How should I read this statement?  Is the False referring to the userState or to the IsDurableCalculatedData Boolean?Thanks,Bob

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.

Hello, Did anyone use Application.DoEvents() in v8.4? I am getting below message during compile even with "Imports System.Windows.Forms". Any help will be appreciated. JC

I'm making a simple event handler rule that sends an email when a workflow is processed. I would like the email to include the datetime when it was processed, the user who did it, the workflow, workflow profile and entity. However I've only been able to include the date and time. My code is structured like this: Main calls the sub XFR_HandleEndProcessCube() Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DataQualityEventHandlerArgs) As Object Try Dim returnValue As Object = args.DefaultReturnValue args.UseReturnValueFromBusinessRule = False args.Cancel = False Select Case args.OperationName Case Is = BREventOperationType.DataQuality.ProcessCube.EndProcessCube Me.XFR_HandleEndProcessCube(si, globals, api, args) End Select Return returnValue Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function XFR_HandleEndProcessCube() sub sends the email, using the help

Namespace OneStream.BusinessRule.Finance.XFR_MemberListAlphabetical Public Class MainClass '--------------------------------------------------------------------------------------------------- 'Reference Code: XFR_MemberListAlphabetical ' 'Description: Use a business rule to sort a member list in Alphabetical order ' 'Usage: This will put a member list of a dimension in Alphabetical order. ' Use the following on the cube view: ' E#Member.[Name of Business Rule, Name of List in Business Rule] ' e.g. E#Root.[XFR_MemberListAlphabetical, EntityAlphabetical] ' 'Created By: Robert Powers (put in XF Ref by John Von Allmen) ' 'Date Created: 5-24-2013 '--------------------------------------------------------------------------------------------------- Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, _ ByVal api As FinanceRulesApi, ByVal args As FinanceRulesArgs) As Object Try

All,I have a form populated with data & I am trying to retrieve the data through the Finance BR under calculate. It is not displaying the data in the error log.Sample Data. I am trying to retrieve the data at Parent Entity with Base ICP intersection. BaseICP - 3000Parent Entity - P10000.2The below is the code If api.Pov.Scenario.Name="Actual" And api.Pov.Cons.Name="Elimination" Then              Dim Entity As String = api.Pov.Entity.Name              Dim Parent As String = api.Pov.Parent.Name              Dim Ownership As Decimal = api.Data.GetDataCell("E#" & Parent & ":C#Local:S#ActualOwnershipCalcs:A#UltimateOwnership:F#None:O#Top:I#" & Entity & ":U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None").CellAmount       &nbs

Looking for some code on grabbing all entities with a text1 field of "ABC" and then run logic on them.  I didnt see anything in the Golfstream app to use.  

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

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.Ge

I'm trying to build a label that shows target goals for each entity. Now since each region has different goals. I'm looking for my label to change the value based on the entity selected.  Here is an example (We're still in development so not the most eye catching) Its referencing a parameter --  How can I pass a condition or a rule that reads the POV entity and shows me that specific value.

Hi All - I have a quick question When I am using the Data Buffer, I am able to write to the Elimination Member.The Same for the Set DataCell as well.When I try to use the same in the Member Script Value it is not writing to the Elimination Origin except forms. Any Idea why ?Below is an example'                        strMemberScript = "Cb#Cube:E#100:C#Local:S#Actual:T#2022M12:V#YTD:A#123456:F#None:O#Forms:I#101:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None"'                                objMemberScriptValue.Amount = 100'                                objMemberScriptValue.IsNoData = False'                                objMemberScriptValue.Script = strMemberScript'

I am updating a customization to the Account Reconciliations solution to version 8.4 and have converted my custom business rules into a workspace assembly/assembly files.I added a custom maintenance unit to the OneStream Financial Close workspace to build said assembly and I am now having issues calling my assembly, specifically, the workspace assembly service factory file I created is not getting recognized.I found an instance of a button in the Reconciliation Manager MU where a button component calls upon the Integration assembly in the Integration MU using the following syntax:{Workspace.Current.Integration.WSMU}{OnOpenDetailItemTransactionDrillbackClick}{ItemID=[|!SelectedReconItemID_RCM!|]}I also have my Workspace Assembly Service that I created set on my custom maintenance unit:So after adding my own custom button (to appear on the Account Recs UI) in the Reconciliation Manager MU, I followed the same logic for executing the call, below is an example:{Workspace.Current.MyAss