Rules

  Does the api.Data.GetDataBufferUsingFormula("FilterMembers(...)") only get cells that have values?  Is there a way to create a data buffer with empty cells?  Use case:  We need to to cycle through an account hierarchy and populate each base account with data from an intersection of a specific Account, UD2, UD3, and UD4 that are defined in the text fields of the particular account that is being populated. The other dimensions of the data buffer are limited to a single member (i.e.":V#YTD:F#End_Bal:O#Import:U2#000:U3#0000:U4#0:U5#None:U6#None:U7#None:U8#None")  

Hello Experts,  I have a requirement of calculating Cash_ADJ based a sum value of 2 different buffers.  If the sum value is Positive I have to post a cash_adj with value from bufSrc2. Is it possible to filter Buffer 1 and write corresponding buffer 2 value to result buffer?  Or the approach has to be completely changed for this requirement?     If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity())) Then Dim destInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("A#Cash_ADJ") Dim bufSrc1 As DataBuffer = api.Data.GetDataBufferUsingFormula("A#Cash") Dim bufSrc2 As DataBuffer = api.Data.GetDataBufferUsingFormula("A#Loan") Dim bufSrc3 As DataBuffer = bufSrc1 - bufSrc2 Dim resultBuf As New DataBuffer () For Each newCell As DataBufferCell In bufSrc3.DataBufferCells.Values If Not NewCell.CellAmount > 0 Then Dim resultCell As New DataBufferCell(newCell) resultBuf.SetCell(si, resultCell, True) End If Next

Hi EveryOne!!!! Dim resultDataBuffer As DataBuffer = New DataBufferDim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("")Dim dataBuffSource As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(F#myF,A#XYZ.Base)") For Each sourceCell As DataBufferCell In dataBuffSource.DataBufferCells.Values BRApi.ErrorLog.LogMessage(si,$">> {sourceCell.GetAccountName(api).ToString} {sourceCell.GetFlowName(api).ToString}" ) Executing the code above I would expect to get base level accounts of node XYZ with Flow Member myF. However, I am getting the base level accounts but the Flow member is XFCommon. XFCommon is not even a Flow dimension member! Any ideas what I am doing wrong !? Thanks!

Hello, When I execute a Data management sequence or a custom finance function, I have this pop-up that will be shown to the user : Are there any ways to customize what will be shown to the user in this pop-up ? For instance, I want to  customize the message that will be shown in the blank text field below "0% Complete" or the message next to the task when it is running : Many thanks for your feedback ! Regards,

Hi, We are working on Consolidation application with 'OOB and Store share' algorithm type. Came across an requirement to eliminate balances on few GLs with C#Elimination and O#Elimination member. Below calculate function worked randomly for few entities (step consol structure) and not for all. Any suggestions to improve on below logic ? Thanks   If api.Pov.Cons.Name.XFEqualsIgnoreCase("Elimination") Then api.Data.Calculate("C#Elimination:O#Elimination = (C#Share:O#BeforeElim) * -1", _ "A#OtherAssets.TreeDescendantsInclusive.Where(Text2 = Others)", _ "F#EndingBalance",,"I#None","U1#None","U2#None","U3#None", _ "U4#TopSide_Adj","U5#None","U6#None","U7#None","U8#None") End If        

Hi. I am trying to forecast OpEx accounts based on a seeding method. I am storing the method on a specific month by account and some UD dimensions and based on the selected method want to apply different math for those combinations. The issue i am facing is that when looping through my original data buffer, where the methods are stored, i need to change the Scenario, Period and View member for the looped databuffer cell and then sotore that value. E.g. if the method stored in 2023M1 is 3MthAvg, i need to grab V#Trailing3MonthAvg:2023M1:S#Actual for each data unit that is being processed (All months for 2023 Budget scenario).     Dim driverDataBuffer As DataBuffer = Nothing Dim calculatedBuffer As DataBuffer = Nothing Dim destinationExpressionInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("V#Periodic:O#Import:U5#NoChannel:U6#NoCustomer:U7#NoProject:U8#None") driverDataBuffer = api.Data.GetDataBufferUsingFormula( _ "FilterMembers(C#Local:" & fir

Finance Business rules can be referenced in Confirmation Rules to ease maintenance. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi, I want to retrieve into a Business Rule and pass it on to a CubeView row label the value stored in a UD text property. ie UD4 Text3 for example presuming that this is relative to the current Workflow Scenario/Time setting In snippets I have found this : 'Dim sValue As String = BRApi.Finance.UD.Text(si, dimTypeId, memberId, textPropertyIndex, varyByScenarioTypeId, varyByTimeId) I am aware that the Text1 property attached to the WorkFlowProfile has the folowing attributes to get the various values stored under each TextN property field.Attribute Index Is: Text1 = 18000, Text2 = 20000, Text3 = 22000, Text4 = 24000 So what is the appropriate syntax in a Business Rule that I could bring in the UDN TextN values. Thanks Mark    

Please provide any guidance or knowledge documents on how to access data stored in table data manager tables via Finance Business rules.

I have a process that causes contention if launched concurrently by users. Is there a way to check if a session with a specific description is already running? I would like to abort the session if another session with the same name is already running. I tried looking through properties and found "GetTaskActivityItem", but the definition and sample are not of much help.

Hi all, I have a dashboard with an SQL table editor component. Through the component in the dashboard, I can save text to the table, including special characters. For example, there is no problem in saving a string containing α (alpha).   Now I am trying to load a CSV file to that same table. The file contains some special characters too. To load the file, I have built a business rule which contains the following command: loadResults = BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, SourceDataOriginTypes.FromFileUpload, filePath, fileinfo.XFFile.ContentFileBytes, "|", "App", "LOAD_TABLE", "Merge", lfieldtokens, True)   The special characters are not recognised, and this is the result when loading TestNameαβπ.   Is there a way to load the CSV file and preserve the special characters?

Hello All,  I am new to OneStream trying to write a Value Override business rule for some investment accounts, The rule works without account filter. How ever I want to restrict this to Accounts with Text2 tag as "CADOverride". Somehow the value becomes zero if I have the Text 2 filter and not sure where am I doing wrong, (I am currently just checking if text 2 is not null and it seems to be retuning empty)   Dim foreignCurrency As String = api.Pov.Cons.Name If ((Not api.Entity.HasChildren()) And (api.Cons.IsForeignCurrencyForEntity())) Then Dim overrideAcc As String = api.Account.Text(api.Pov.Account.MemberId, 2) If String.IsNullOrEmpty(overrideAcc) Then Select Case foreignCurrency Case "CAD" api.data.calculate("F#EndBal= RemoveNoData(F#CADOverrideInput:C#Local)") End Select End If End If   How should I proceed to troubleshoot this? Any ideas are appreciated, Thanks, Manoj

An api is passed in, but typed as Object, what is object type of the correct/most efficient API to use in an Extensibility Rule to call Members.GetBaseMembers()?

I want to have an account that has a calculated value (rounding it to thousands), and then allow a Forms input adjustment to it for footing reasons.  The calculated value would have a UD4 of "Calc", and the input would have a UD4 of "Footing".  As soon as I make the account calculated it doesn't seem to let me input to it with the other UD4.  It shows in white background indicating you can input, but I can't put anything in the cell.  Anyone know if what I'm trying to do is possible?

Hi all, Is there any way to automate workflow creation and step renaming using business rules ? Can someone provide an example please.  Thanks for the help.

Hi Team, Could you please let us know if it's possible to use the function math.pow in a databuffer? and if yes, which is the correct syntax? As for example Dim resultDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("Math.Pow(($sourceBufferMonthlyRate),$sourceDataBufferResidual)") or maybe in a api.Data.Calculate function?  Thank you in advance! Giorgia

Hi, Does anybody have a example of an business rule to import data from Sage with an API?  

Hi everyone, I need to retrieve the account name from a certain line in a cube view in an XFBR rule.  So, it boils down to the need for an api.Pov.Account.MemberId XFBR equivalent.   Is there anyone that can help me with this issue? It seems so simple but I cannot figure it out. Thanks! Floris

OS Version 7.3.3My files are stored in a Named Workspace, "Finance WS"I want to open a file stored in Finance WS.  How do I get the workspace guid to accces the file? Dim guidWs as Guid = ???BRApi.Dashboards.FileResources.GetFileResource(si, False, guidWs, strFilename)

1. I am trying to export as trx for the derivative rule with a business rule in it. 1a. Once it exports, the exported file doesnt have the business rule name in it. (OR)2. Exported the rule as xml via application export and then opened it in the excel file as XM table. However, once i add rows below it and then try to export the file -> It says cannot export.   How to insert multiple lines in the excel and get tehm exported as xml for onestream input ?  

Hi, I have a matrix data source matrixed on Account.  Sample below.  One of the Account fields is a Date that I need to convert to a Long to store.  I can do the conversion but not sure how to target the value to convert when in a matrixed data source. If it were a delimited data source I would use: Dim sDateField As String = api.Parser.DelimitedParsedValues(6).  Is there a way to identify the value in a matrixed data source? thanks Greg Code1 Entity Account1 Account2 Account3 Test1 Entity1 1/1/24 0.025 0.5 Test2 Entity2 5/1/24 0.025 0.5 Test3 Entity3 3/1/25 0.025 0.5

If an API and a BRAPI accomplish the same action, like returning a text field from an account, a developer can use either without consequence in a Finance Business Rule. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi All,We're running into a few problems with an existing BR that is used to change the state of the current workflow. The current BR is used in the admin workflow & we haven't encountered any problems, however when end users attempt to run this rule on a child workflow, they receive the error message below.Business RuleIf args.FunctionName.XFEqualsIgnoreCase("WorkflowStatusUpdate") ThenDim strChangeType As String = args.NameValuePairs.XFGetValue("ChangeType")Dim selectionChangedTaskResult As XFSelectionChangedTaskResult = Me.WorkflowStatusUpdate(si, strChangeType)Return selectionChangedTaskResultEnd IfWhen an admin progresses the workflow the end users are able to execute the subsequent steps to complete their workflow. Is there something I'm missing in the current rule that needs to be changed or is this an issue with our security setup?Thanks,

I am trying to figure out how to share a structure between OS BR files. In an Extender BR file named ExtenderBR I have:   Public Structure MyStruct Public Element1 As String Public Element2 As Boolean Public Element3 As Integer End Structure Public Function MyFunct1() As String Return "" End Function Public Function MyFunct2() As MyStruct Return New MyStruct End Function   In my Finance BR file, I include the BR\ExtenderBR from above and include a line   Dim ExtenderBR As New OneStream.BusinessRule.Extender.ExtenderBR.MainClass Dim xx As String=ExtenderBR.MyFunct1() 'This works ExtenderBR.MyFunct2() 'Generates error, as the Finance rule doesn't know about the custom Structure   Any thoughts how to share MyStruct across multiple OS Business Rules files?

Hello, I am trying to create a FX Scenario - Acutuals at Prior Year Rate. I know i can use Constant Year For FX Rate and assign the year from which OneStream will pick Actuals rate in this case. But i dont want the user to be changing this property every year. My approach is to set "Translation Algorithm Type" to "Standard Using Business Rules For FX Rates" and create a custom translation for that specific scenario "Actuals at Prior Year Rate".  Does anyone has the logic to translate the scenario using Actual Exchange rate tables switching one year back from the POV being translated?