Rules

I'm running a SQL query to display the data as if it were a QView, but I realized that the table I was using didn't contain the values it should. SELECT EntityId, UD1Id, UD4Id, TimeId, ICId, Amount, FlowId, ConsId FROM DataEntryAuditCell WHERE ScenarioId = ( SELECT MemberId FROM Member WHERE Name = '|WFScenario|' ) AND CubeId = 4 AND ICId != -999 AND AccountId = 17826015 AND Amount != 0 AND FlowId IN (1048639,-999) AND UD1Id != -999 AND UD4Id != -999 The reason for using SQL is to facilitate user access to that specific information, as a QView wouldn't display everything according to the required permissions, which in this case doesn't apply as

Hello,  If anyone needs to sort a specific account group by ascending. This is the codes it worked. Sub RemoveandSortAccounts(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardExtenderArgs) Dim ParentGroup As String = args.NameValuePairs.XFGetValue("ParentGroup") Dim osAccountMember As Member = BRApi.Finance.Members.GetMember(si, dimtypeid.Account, ParentGroup) Dim actDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "ST_Accounts") Dim osBaseList As list(Of Member) = BRApi.Finance.Members.GetChildren(si, actDimPk, osAccountMember.MemberId) Dim osBaseList2 As list(Of Member) = BRApi.Finance.Members.GetChildren(si, actDimPk, osAccountMember.MemberId) osBaseList2.Sort(Function(x, y) x.Name.CompareTo(y.Name)) If osBaseList.Count > 0 Then For Each baseMember As Member In osBaseList 'osBaseList '===Remove first==== Dim PId As Integer = BRApi.Finance.Members.GetMemberId(si, dimTypeId.Account, osAccountMember.Name) Dim myId

Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample"  button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code after you created the block, just double-click on it. Ideally you'd also indent it first, either in an editor or with something like DotNetFiddle. Remember: the easier it is for others to read your code, the more likely that they'll be able to solve your problem! Cheers!Your friendly neighborhood Spider-Mod

Looking for function in the business rules to derive prior quarter based on the year and month value passed from parameter?

SOURCE: ONESTREAM CHAMPIONS Company has a hard carriage return in their file for a couple of description fields. They are struggling to fix it on their side. Is there code that can be written for the data source to remove this hard return and get everything on one line? Appreciate any guidance or snippet of cod

Spoiler (Highlight to read)   Summary: Error processing Data Management Step 'App2App_Parallel_Step'.Unable to execute Business Rule 'App2App_Parallel'. An item with the same key has already been added.

Hello, Can we figure out sibling sort order for existing members and add the new members at a specific position in hierarchy through extensibility rule? Any samples would be helpful.

Hai everyone,             I am trying to access the data from excel through business rule and use it in the business rule.If anyone know the VB.net code,please share with me. 

Hello, I an trying to write a calculation to divide one number by another one and have it to flow into a new account. Below is the formula I am using, but I am not getting the date to calculate. Can someone assist on how to write it correctly.    Calculate("A#mpg test","Divide(A#33010, A#33005)",deptFilter)

We’re looking for some kind of way to reference dates in the transaction matching custom filter. For instance I need to be able to reference an attribute (like A9 = ‘ABC’) and also only pull items for D1 = yesterday and then pull another attribute (like A9 = ‘XYZ’) and also only pull items for D1 = two days ago. So the filter would look something like: (A9 = ‘ABC’ and D1 = yesterday) or (A9 = ‘XYZ’ and D1 = two days ago)

Hi everyone! I'm currently building a linked cube view that will inherit the Entity and IC members from the original cube view from which it is called. The IC member, though, will need to go through a transformation (remove the last 3 digits) so I created a XFBR rule to do so. For example, if the Entity member will be 1010TRW, the IC will be 1010. I tried to call the XFBR rule in the POV but when I launch it it returns the following error: "Index and length must refer to a location within the string."   Am I missing something? Below you can find a screenshot of the POV of the linked CV Thank you in advance!

Hi  I create OneStream parameters for the fields that I want to bring in from OneStream into an extensible document in order not to mess up the formatting of the document as the formula is very long to pull the data into OneStream.  Now I want to create a parameter that uses a business rule to check if the amounts for one line of the two year's  income statement (This year and last year) lines are both positive, then put "Profit" in the text of the account or "Profit/Loss" if the one amount is positive and the other is negative or "Loss" if both amounts are negative.   How do i do that ?     

Hi Everyone, We have multiple cubes in an application. Is there a way to retrieve the cube name using the entity dimension member. I have multiple entities in a excel sheet and I need to get the cube names for them. I tried the =XFGetMemberInfo(memberInfoType,dimTypeName,memberName). It did not work.     Thanks  

Hi OS Community, I am just wondering if any of you had a chance to build dynamic member list or some similar functionality which allows you to have a specified member list which will be used in a parameter (XFBR). I am having trouble to achieve that... What I created is parameter supported by simple business rule which also use information coming from another parameter. This is working well but only if second parameter which i am using is not part of POV parameters. Looks like I can not use parameter inside used parameter. where this second is also used in CubeView POV... Let me try to describe you on example what is my problem, maybe some of you will be able to help.  What i would like to achieve is to have some connection between entity selected in the cubeview POV and UD1 list of members which then will be presented as a list of members to choose inside parameter and CubeView POV. Example: I have a CubeView with POV where parameters are used for below dimensions :EntityUD1UD2UD

Hey all, Pretty new to programming but have manage to get a file moving rule to work that basically moves a file from FileShareBatchHarvest to Application /Public structure for users to pickup.  However, the rule currently needs the exact name of file. I have tried using wildcard symbols like "* #" for the date with no success.  Does anyone have a recommended solution to get the variable dynamic on the date section?  

Hi All, does anyone built a Smart Integration Function and compressed the datatable with CompressJsonObject and then, in the extensibility rule, inflate it with InflateJsonObject using the variable bulkRemoteResults.resultDataCompressed ? I'm getting the error: "Object reference not set to an instance of an object". If I compress itand inflate it in function worked and in the extensibility rule worked. But, compress in the function and inflate in the extensibility rule didnt work. This is an example in the guide, so I'm not sure if I'm missing something. Thx in advance

Hello Community - Looking for guidance on options to calculate data at QTD to overwrite the number generated from periodic values. This intersection has an option for users to enter periodic values, so I cannot make a member dynamic calc. I am using UD8 dimension member for the calc. Please share your thoughts. Thanks!  

Hello Community, Is there any functions in Business Rule which is related to T#QuarterPrior1...?I'm getting only this following function, Dim timeMemberIdPrQua As Integer = TimeDimHelper.GetLastPeriodInPriorQuarter(timeMemberId) So can you please help me to get this...!

Dear Community, Can anyone please guide me the proper usage of the function  BRApi.Database.SaveDataTableRows(dbConnApp, tableName, columns, hasPrimaryKeyColumns, editedDataRows, throwIfRowForUpdatesDoesntExist, throwIfRowForDeleteDoesntExist, logErrors) I would like to understand the correct usage of  XFDataColumn and XFEditedDataRows in the above function, would appreciate any assistance. Thank You.

Hello Everyone, I’m not sure if I’m not understanding or just approaching the code wrong.  We’ve been on OneStream for about two years and myself and my co-admin are not extensive in our code knowledge.  We can generally copy/tweak what the implementation partners build, or searching the forums here, but I’d put us as basic or being generous intermediate level. We have a workflow that loads to the actual scenario and has some workflow steps at the end that are for a variance scenario where the users enter commentary balances. The Variance scenario steps auto lock when certified and I want a business rule to unlock the variance steps if the Actual Import_Ledger step is re-run. I have code in the TransformationEventHandler rule that accomplishes this for me, but when users are running the import it gives the error of user has not been granted access to application role “UnlockWorkflowUnit” I thought (possibly erroneously) that by using a business rule the system would allow unl

Hi, Is there a way to perform a force consolidate in a BR? since running a datamgmtsequence isn't working properly for me. Example: Select Case api.FunctionType Case Is = FinanceFunctionType.CustomCalculate 'If args.CustomCalculateArgs.FunctionName.XFEqualsIgnoreCase("Test") Then 'api.Data.Calculate("A#Profit = A#Sales - A#Costs") 'End If brapi.utilities.ExecuteDataMgmtSequence(si, "PLN_Consolidate_AnyScenario", Nothing) End Select And with this, the consolidation doesn't run; I'm not sure if I'm missing sending information or something like that.

May I have an example of how to use "DynamicCalcTextInput" Formula Type? I cannot find the place to put text annotation without using data cell annotation.   

Hi all,  I am facing an issue regarding my ability to reference global objects between two different business rules, one of which is a finance business rule and the other of which is a connector business rule. To be more specific, the flow goes like this:  First, I execute the finance business rule function that generates my global object, which is a DataTable, from a connector business rule:  BRApi.Finance.Calculate.ExecuteCustomCalculateBusinessRule(si, "Utilities", "GetDataTable", povInfo, CustomCalculateTimeType.MemberFilter) Then, in the GetDataTable function of the Utilities finance business rule, I create a DataTable and save it as a global object: Dim dtCEDR_Integ As New DataTable("CEDR") 'add data to data table globals.SetObject("dtCEDR_Integ", dtCEDR_Integ) Then, back in the connector business rule, I try to get that global DataTable object. Dim dtCEDR_Integ As DataTable = globals.GetObject("dtCEDR_Integ") However, when I attempt to import the

I'm trying to use the DataBuffer.GetFilteredDataBuffer() function which returns a DataBuffer.  This function takes two parameters as follows: 1. DimTypeForFilter as DimType;  If I'm filtering for accounts this is DimType.Account.  DimType.UD1 for UD1, etc. 2. Now I'm having trouble with the second parameter.  memberIdsInFilter As Dictionary(Of Integer, Object) I find no examples on this.  Please help with an example.  

Has anyone found a use for the brapi function CreateSessionInfoForAnotherApp? If yes, can you please explain it as I cannot seem to find any documentation on this function.  This is the example I'm seeing in BR: Dim si As SessionInfo = BRApi.Security.Authorization.CreateSessionInfoForAnotherApp(siSource, appName, openAppResult)   How do we setup the siSource sessionInfo parameter? Assuming that siSource needs to be initialized with info from the sessionInfo from another active app connection? What can we then do with the si from another application? 🤔