Rules

What is the purpose of timeMemFilter, entityMemFilter and scenarioMemFilter parameters for the below function as these will be defined in the cube view? Is there a way to extract aggregated members as a table for the Account and all the UD1 to UD8 dims. Cube views have a limitation of 4 dims on the rows. This is required for an auto feed using OS REST api calls for an external system. We can export base data, dim structures using api calls and perform the aggregations in the external system but wanted to explore the option of aggregated data exports.   BRApi.Import.Data.FdxExecuteCubeView( si, cubeViewName, entityDimName, entityMemFilter, scenarioDimName, scenarioMemFilter, timeMemFilter, nvbParams, includeCellTextCols, useStandardFactTableFields, filter, parallelQueryCount, logStatistics )  

Hi all, I am creating a Reporting UD8 node that provides an on-the-fly calculation of the consolidated data at Budget Rates.It is working (mostly), except for one aspect that relates to the pulling of the percent consolidation data for the base nodes of a higher level parent. In this case,  the percent consolidation for that node is not being picked up correctly. Here is the approach I have taken within the script and the steps to test / resolve. The scripting takes a simple approach of picking the Entity node queried and then pulling the appropriate level of base data, so cycling through all Entity base nodes of a given parent, pulling the PCON, Ex Rate and data point from Actuals in the local layer, and multiplying them together, then cycling through to the next base node.In terms of issue, the issue seems to be if i pick a parent that has one or two layers of parent / children beneath it, it fails to retrieve the correct  PCON information. What the formula does ( a li

A1=100,A2=200 -> Both are Revenue account type and doesnt have any formula.D1=A1+A2 ->Account type and Formula type -> Both are dynamicCalcD2->Account type and Formula type -> Both are dynamicCalcWill the below formula works?D2=D1+100

Hi,We are using the following when we send out the automated email, and it works just fine. However is there a way to include the application name in the email? Reason being we would like the users (some who have access to Dev etc to be able to decipher from production application. BRApi.Utilities.SendMail(si, "OneStreamEmail", toEmail, "SAP Load Automation Errors in: " & gTime, "Please see the attachment for error details.", attachments)Thanks!

Hi Everyone!.I have the problem that a button is applying processes to a closed Forecast, for example, the open forecast is for June, but a user could select March or April and reapply those processes to those months that are supposed to be locked. In my case, it applies those processes even when the selected Forecast is closed, so it would help me if you could show me a way to validate it in the BR so that that process does not run (By process, I also refer to Data Management or a Business Rule).

Hi,I've created a tree view component using a business rule which works as expected. The part I'm struggling with is to make it so that it automatically scrolls to the selected tree view item when the dashboard opens like it does when selecting a new workflow view. Does anybody know how to do this?

Hi there,I'm seeking assistance with a specific requirement. I need a business rule to operate as follows: upon initial execution, it should function normally. However, if a user attempts to run it again, there should be a designated wait time before the next execution.For instance, if I initiate the business rule at 16:00, it should not be possible to trigger it again until 19:00, ensuring a 3-hour interval.To implement this, I intend to leverage the Task Activity Log Start Time. I'm using OS 6.3Any guidance on achieving this would be greatly appreciated.

Hi All,  For a client i've created a SQL script that generates a datatable that i want to save to a .csv file. This works as expected via        BRApi.Utilities.SaveFileBytesToUserTempFolder(si, si.UserName, sFileName, fileBytes)       From this location i can present the file to the user from the dashboard button that is generating the export. However, this file is big and the user settings (of some users) change the number formatting of the export. Therefore i want to export the file directly to the shared folder (which is easy for the user to access from the front end:   I've tried all options within brapi.FileSystem but cannot find the proper syntax to save this file directly. The 'issue' is currently solved by storing this file in the user temp folder, then copying it over to the shared folder (via another article on this forum) but that touches the file twice so preferably i want to save the file directly from the fileBytes (that is a

I'm making updates to some BRs that predate any of the current employees and when validating the rules I get warnings that I'd like to resolve. Specifically, these: 'Public Shared Overloads Function CreateSubstVarSourceInfo(dbConnFW As DbConnInfo, dbConnAppOrFW As DbConnInfo) As SubstVarSourceInfo' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'. 'Public Overloads Function GetBusinessRules(si As SessionInfo, brType As BusinessRuleType) As List(Of BusinessRuleSummaryInfo)' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'. Public Overloads Sub DeleteBusinessRule(si As SessionInfo, brType As BusinessRuleType, brName As String)' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibil

Hi all, I need to call this parameter to get the results in a member List of a BR:In this case, I would need to get a list with the values 6620 and 7610 in a Business rule of type spreadsheetPlease, could you help me with any function to call this parameter and get this values?Thank you so much in advance! 

Dear community, I'm using some confirmation rules but the output is not what I'm expecting. I'm using a very simple check to see if assets and liabilities are balanced, however it's not running on the expected entities. I have set the Calculation definition for 3 entities which are the parents of the entities managed in the workflow profile. These parents are actually linked to a "parent input" profile type, but all of their children are related to this workflow profile. I have then a confirmation rule that is looking for the assets & liabilities : args.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell( _ "A#00068:C#Local:F#F0999:I#Top:C#EUR:V#YTD:O#BeforeAdj - A#00084:C#Local:F#F0999:I#Top:C#EUR:V#YTD:O#BeforeAdj" _ ).Cellamount If System.Math.Abs(args.ConfirmationRuleArgs.DisplayValue) = 0 Then Return True Else Return False End If    However when I run these confirmations as a user, I invariably get the output related to the POV entity

Hi All,I want to copy Data seed from one scenario to another scenario.(example current year actual to Prior year actual Scenario with different rate.can anyone help on this

Hello,Is there an event handler or dashboard extender rule that could be used to stop a user from completing a workspace if certain steps are not completed first? I have a workspace that needs to be completed, but only after the import, journals and certain forms are completed first. We don't want to lock the workspace, rather when they go click the "Complete Workspace" button it gives an error message that they need to finish the other steps first. Thank you!

We are still in the development stage of our OneStream implementation.  We are currently running 7.4.  When v8.0 came out, I started doing some research on .NET6 (and 7).  It appears that Microsoft is more focused on CSharp than they are on Visual Basic.  I believe, eventually, Visual Basic will be deprecated.  With this in mind, and since we are still in development, I was thinking about converting our VB business rules to CSharp and using that language going forward.I would like the feedback of the OneStream Community before I take this project on. Thank you.

Hi everyone! I have two entity hierarchies, one in currency EUR, and one in USD. I need to create a cube view to retrieve the FX rates based on the parent’s currency. I’ve created an account, for example ClosingRate, as a DynamicCalc. I am using this formula to retrieve the rate: api.FxRates.GetCalculatedFxRate(rateType, cubeId, timeId, sourceCurrId, destCurrId)   For the destination currency, it’s straightforward: Dim destCurrId As Integer = api.Pov.Cons.MemberPk.MemberId But I am unsure how to set the source currency as variable, I usually either set it to EUR, or USD. Dim sourceCurrId As Integer = Currency.EUR.Id Is there a way to get a parent’s currency? Or, I had another idea. To create a Text1 property at the level of each entity base member, to specify the Parent’s currency. I can retrieve it in the script as a string, but after that I don’t know how to get the Id. Appreciate your help! Thank you!

hi,Two account A and B needs to be subtracted in the source applicaiton and assigned to the third account on destination application  in the transformation rule for App2App copy process . Below is my Composite but its throwing error for one-one transformaton mapping.  TR Composite Rule:Validaiton error:  

Hi guyswe frequently work with data buffer (or sometimes even with setcell) and there's a problem for which I coudn't find a solution. E.g. we have an allocation setting the values to certain intersections in the target data buffer. If among all cells to write some of them are invalid intersection (not within the constraints of the account for one or more Flow/Ud element), there's no error and they are simply not written. From here: is there a function to test an intersection and check whether it's valid or not? Is there a function to do that for the whole databuffer without loops and get the list of invalid records?Even worse, sometimes the target members don't exist and we just get an error. But I need to log the data buffer and investigate each single row to identify where the problem is. Is there a function or a best practice to get a log with the rows in error in case the target members don't exist?We found this function(s) api.Account.IsFlowICOrUDMemberWithinConstraintM

I am debugging some business rules.  I would like to add a Console.WriteLine, but I am not sure where that gets written to.  I would like to avoid clogging up "Error Logs" and a simple MsgBox is not enough. Any suggestions on where to look? Thank you.

Hoping someone in the community might have a solution for this and is willing to share a snippet of code that will enable us to properly 'clear' any data (including zero) from a specific intersection so that we can delete a metadata member.The DM step "Clear Data" is simply too all-encompassing to use in this case and we need to be more surgical in our approach.Thanks in advance for any assistance.

I have application which has 47 entities and users who have Entity wise rights to upload TB/Reclass and Cube views. So far Admin is downloading TB  manually (using view source document) by going through Entity.  Now I want to download TB and Reclass files through some business rules (if possible to be schedule to run once in Month) or some procedure for all entities using user who has administrative privilege.   Thanks all in advance for your help. Regards, Yashwant

Hi,I need to create an account to calculate two values multiply together.I had set formulapass2 and set the formula as below:api.Data.ClearCalculatedData("A#COG762D:U1#None",True,True,True)api.data.calculate("A#COG762D:U1#None = A#COG931:U1#ALLDEPT * A#KPI142:U1#1520")It shows zeros while A#COG931:U1#ALLDEPT is 100 and A#KPI142:U1#1520 is 25.May I know why? Thank you.

Hi All, I want to seed the data from below source, please help me how to write a code for the below data copy. Target:- api.Data.Calculate("V#PERIODIC:O#Import:U3#" & UD3 & ":U8#UND_UD8:U4#" & CurrWk & "= Source:- RemoveZeros(S#Actual:U4#TOP:T#" & Priortime & " - S#Weekly_Processes:U4#Week_1:T#" & Priortime & " - S#Weekly_Processes:U4#Week_2:T#" & Priortime & " - S#Weekly_Processes:U4#Week_3:T#" & Priortime & " - S#Weekly_Processes:U4#Week_4:T#" & Priortime & ")","A#KPI_PPV_MONTHLY,A#KPI_TOT_PURCH_DPO",,,,,,,,,,,"U8#Top",,,True)

Hi all,I'm currently developing a dashboard for a client and I need to assign a literal value to a dashboard parameter from the BR code. I'll try to explain the issue better:I created the following parameter "test" within a dashboard group: within the BR, I entered the following: In this case, I'm trying to assign the text "SampleText" to the parameter "test".I then created a combo box, I assigned the parameter "test" as a bound parameter, and placed the combo box in the dashboard: My goal is that, once triggered the BR, I will be able to see "SampleText" in the dashboard. Once the BR is triggered, though, no value is assigned to the parameter, and the combo box remains empty. What am I doing wrong? 

I am trying to get the Text1 field value using a Business Rule and put this value in a cube view that is being used as Form. Does anyone have done this before? Is it possible to get the Text1 value from the Workflow Profile using BRApi? Thanks for the help.  

Hi - Is there an BRAPI to get the current form name from WF Profile ? I was able to get the list of Forms using the below code but I looking for when a user select the form it should return. Let me know if there any BRAPI functions  Thanks  Dim objBRApiForms As XFFormsForWorkflow = BRApi.Forms.Metadata.GetForms(si,si.WorkflowClusterPk) 'Get the List of Required Forms Dim listfrm As List (Of XFFormSummaryInfo) = objBRApiForms.OptionalForms