Rules

Hi, Does anyone have an example where multiple dbwheres on the same column are executed?The syntax seems to support AND/OR, but I can't seem to get it working.  I have the following dbWheres (without the AND/OR part): Dim dbWhereEntity As New DbWhere("Entity", dboperator.In, entityFilter) Dim dbWhereResignationDate As New DbWhere("TermDate", dboperator.IsGreaterThan, dateEndOfMonth) Dim dbWhereResignationDate2 As New DbWhere("TermDate", dboperator.IsEqualTo, Nothing) Individually, the ResignationDate dbwheres seem to work. The SQL statement needs to look something like this: SELECT * FROM MyTable WHERE (TermDate > @DateEndOfMonth OR TermDate IS NULL) AND Entity = 'MyEntity'; (I know I could build a SQL statement and execute that as a work-around, but I'm just curious how this works) Any help is appreciated, thanks!

I am receiving this error when writing a business rule, any idea on how I can remove this error? Here is the portion of the business rule where I am using 'si': Dim objXFResult As XFResult = BRApi.Finance.Data.SetDataCellsUsingUsingCsvFile(si, filePath, delimiter, originFilter, targetOriginMember, loadZeros)  

Hello, We experience performance problems when we try to export Onestream data for insertion into a third-party system.For 100 entities and 12 months, processing takes 20 hours and is often killed by the system.Apparently, it's the dynamic accounts that take up a lot of time during extraction.Do you have the same problem and what are the solutions to optimize the export?Thanks

Hi, I've been looking into the audit trails for O#Forms and O#Import data. The audit trail for O#Forms data seems to be in good shape, with changes tracked in tables like DataEntryAuditCell and DataEntryAuditSource.For O#Import data, I've found some audit information in the staging area tables, such as StageArchivesInformation and vStageSummaryTargetData. However, this doesn't cover everything - for example, it doesn't account for data that's been imported but not yet loaded into the cube, or data imported using a business rule.Is there a way to get a more complete audit trail for O#Import data, that focus on the Cube data rather than Stage data?

Hi,I need to check in a Table View if certain column values are dirty and I've noticed that when you call the IsDirty() function on any decimal type column (and this only happens on that type), it always returns 'true' even though no changes took place.Because of this i need to manually parse the value and check if the originalValue is different from the current value.At this point I was wondering if this behaviour is intended or not, it seems odd that IsDirty() returns the correct value for every type of value BUT a decimal one.Any clarification on this matter is appreciated, thanks in advance. 🙂

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.

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?

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 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?  

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

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

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

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

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

Data Mgmt sequence and steps work great when utilizing a 'manual' initiation of this process and business rule. However, the DM process automatically initiates twice daily at specific times using the same code and rules. When this occurs, it fails on occasion (not always), and this error message is received: Summary: Error processing Data Management Step 'ProcessRecons_RCM'. Unable to execute Business Rule 'RCM_DataMgmtProcess'. One or more errors occurred. () Concurrency violation: the UpdateCommand affected 0 of the expected 1 records. This is the business rule in use... asking if anyone can spot an obvious issue I have overlooked or might know the cause of the failed task on occasion. Business Rule: Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As Object Try Select Case args.FunctionType Case Is = ExtenderFunctionType.ExecuteDataMgmtBusinessRuleStep 'Prepare Parameters Dim wfProfile As String = args.Na

Hello All, OS experts - Greetings ! I am trying to complete the following code to extract the year and month from a given date. To help with validation and debugging, I've enabled BRAPI.ErrorLog.LogMessage to display the variable outputs in the error log. However, for some reason, it is not displaying any values in the error log. I would greatly appreciate any insights into what might be wrong with the code. Here is the code I am working with: Dim vDate As String = args.NameValuePairs.XFGetValue("Date")' e.g., "01/01/2025" (MM/DD/YYYY format) ' Log the retrieved Date for debuggingBRAPI.ErrorLog.LogMessage(si, "vDate: " & vDate) ' Ensure vDate is not null or empty before proceedingIf Not String.IsNullOrEmpty(vDate) Then    ' Extract the year (last 4 characters) from vDate and convert to an integer    Dim vYear As Integer = CInt(vDate.Substring(6, 4))    BRAPI.ErrorLog.LogMessage(si, "vYear: " & vYear)     ' Extract the month (first 2 chara