Rules

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,

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

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

Hello OneStream Experts, Our consultant team has build custom Seeding dashboard for us to seed data but I would like to add confirmation before my admins click on seeding button to make sure they got source and target right.   Do we have anything in OneStream where I can have msgbox or some kind of message to double check source and target section?   Saurin

Hello, I'm attempting to leverage the UD8 Compound Annual Growth Rate (CAGR) business rule as a dynamic calculation.   The formula works great on most intersections, but I keep getting this error message on certain intersections: --> Unable to execute formula for member 'xxx'. Value was either too large or too small for a Decimal.    Does anyone know what is causing this our how I can overcome?  Even a single intersection error wrecks my cubeview presentation as you can see with the attached image.   I'm able to recreate the math in excel and the result doesn't seem unwieldy, so I'm not sure how to resolve.    Thanks, SeanUD8 CAGR Business RuleError Message being thrownMath - highlighting intersection with error via a QuickView  

After validating data in the XFSqlTableEditorSaveDataTaskInfo.EditedDataRows property collection, if a record fails validation, I set the XFSqlTableEditorSaveDataTaskResult.CancelDefaultSave property on saveDataTaskResult = True and return it.  SQL Table Editor still saves the data.  Same if I set it to False.  Am I missing something?Code:         For Each xfRow As XFEditedDataRow In saveDataTaskRows isValid = validationHelper.IsValidDetails(xfRow) If (Not isValid) Then saveDataTaskResult.IsOK = False saveDataTaskResult.Message = $"{saveDataTaskResult.Message} {Environment.NewLine} {validationHelper.validationMsg}" saveDataTaskResult.ShowMessageBox = True 'SQL Table Editor still save the updates 'regardles whether this Is True Or False saveDataTaskResult.CancelDefaultSave = True Exit For End If Next Return saveDataTaskResult              

Curious if anybody knows how to accomplish something I am trying to do.  We have a few DM jobs that are pretty intensive that we run over night and once that job runs it seems like the server it ran on gets bogged down and eventually that server turns red, stops responding and jobs get hung up.  What I would like to do is add another step that says once my big DM is done restart that server but I don't want to force restart it in case a user is currently running on that same server.  So I want to do something similar to what happens in these "recycling" options so that once it gets to the recycle server step in the DM job it stops accepting new jobs and waits until all current jobs are done running then restarts that server.  Curious if anybody knows how to accomplish this or something similar that would fix my issue.  

Hi All, I am trying to solve for a circular calculation pass with allocations.  I am using the equity pick up functionality on the entity properties.  It wasn't behaving for me.  In reading the Design and Reference Guide I see is says " When writing formulas, use api.Args.CalculateArgs.HasRepeatCalc and api.Args.CalculateArgs.IsRepeatCalc to determine if the engine is currently running the repeat calculation".   When I look at the sample code for HasRepeatCalc, it just has Dim bValue as Boolean = args.CalculateArgs.HasRepeatCalc.   I am looking for a practical example of how to use this calculation.  Other than that little piece in admin guide, I can't find any other information on it.  Not used in the GolfStream app either.   Any ideas would be welcomed.    

I'm writing a business rule that will extract the original imported TB files loaded at month end for each import workflow (which may have multiple files per period), rename the file with the time, wfprofile, and load time, move all load files for all workflows to one period folder, and delete the individual wfprofile folders autocreated. I've been successful with all of the asks above, except I'm having trouble extracting the filetimestamp to insert into the new filename. I've found the desired FileTimeStamp field within the stagearchivesinformation table where the sourcefilename matches the filename extracted, but not sure how to reference that field...  Any suggestions?   EXTENSIBILITY RULE: Namespace OneStream.BusinessRule.Extender._BR_ExportTBLoadFiles_Period_TimeandWFPublic Class MainClassPublic Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As ObjectTry'DEFINE THE WORKFLOW CLUSTER USED AS THE STARTING

Hello, Is it possible to create a business rule that sends an email with an attachment where the file that is being attached is saved in the application database rather than the file share?

Hi all, We are running "force calculate" step to perform force calculation of 80% base entities  . It runs for 4-6 hours. How to improve performance , any way run this in multi thread/parallel by entity (servers are hosted by OneStream) ? Thanks!

How to improve the business rule performance using Parallel.ForEach() in OneStream. 

Hello,   I am requesting some assistance. I am trying to write a business rule that will exclude " 1 account and 1 department combination" from and entire rollup. For example, the all included account that is pulling is A#equip_rev and I am trying to exclude Account#410000, Dep#190 from the rule. Do anyone know how I should right that rule to exclude that account/department combination? Your help and feedback is greatly appreciated. 

Hi. I've created a multiselect parameter where the selection will be passed into another parameter. Param1 -> Multiselect combo box(Eg: Level 2 members selected as "US" and "ASIA") Param2 -> Should be populated based on the Param1 selection(Eg: Level 4 members "NY","PH","AZ" of "US" and "IND,SG,TH" of "ASIA" should be listed) Below options dint work. U1#Root.List(|!Param1!|).Base U1#|!Param1!|.Base Need suggestions

Hello, Is it possible to modify datamanagement job description on the fly ? We want adding more info for monitoring issues.  

Is it possible to create a popup msg in a DM business rule like the msg below (created when 'Complete' is clicked).  The Load button calls a DB business Rule and I need to first check if WF channel is locked or not.  If locked I'd like to notify the user that the channel is locked and the BR is running    

This was posted originally in 2019 and added to Office Hours in 2021. Please See below for follow-up question: Question:  Is it possible to have a historical override for a single account, but for multiple currencies?  If I have an equity account which I would like to have a USD override amount, a GBP override amount, etc.  On the Override account settings, I can only choose 1 currency.  How can I resolve this? Answer Yes, this is possible but on your closing balance Flow member, you will have to use a rule instead of the “Source Member for Alternate Input Currency” property, since as stated in the question, you can only choose one member here. The flow would look something like this: Opening Activity FX Closing This member would have a rule that uses this logic: If base entity and foreign currency then   If currency is EUR, then = Override_EUR   If currency is GBP, then = Override_GBP, etc… End If Overrides (one for each potential currency you

Hi OSAdmin  We have a use case where the existing base entity members will be removed from the parent entity and the data of existing base entity member or the parent entity member needs to be copied into the new base entity that will be created under it, is there a way we can achieve this within cube through Business Rules or Data Mapping after metadata updates are applied and without asking users to update/adjust manually  The above can happen with multiple parent child combinations.   Before Metadata Change Hierarchy A (Parent entity) - Data - 40      A1 (Base entity 1) - Data - 30     A2 (Base entity 2) - Data - 10   After Metadata Change Hierarchy A (Parent entity) - Data - 40      A3 (Base entity 3) - Data - 40 Orphans     A1 (Base entity 1) - Data - 30     A2 (Base entity 2) - Data - 10   Thanks, Vishal Pai

Dear community, I am currently using FDXExecuteCubeView in order to get only data coming from a cube view that the user is selecting into a business rule data table. However, FDXExecuteCubeView need to specify the entity & scenario member filters which is a pain when these are parametric. --> So I was wondering if there are other way to get the data coming only from a cube view ? I was thinking of a data adapter component but it seems that the cube view passed in those can't be parametric (ie. the name of the cube view can't be a parameter). What are the other, possible better way, to get only the data coming from a cube view ?   Regards,