Rules

Hi team, We are encountering an error when running a button that involves a Data Management (DM) step to a Business Rule (BR). The error message is as follows: "Summary: Error processing Data Management Step 'SAVE_DRIVERS'. Unable to execute Business Rule 'PLP_HLFPLPCopyAdminDriver'. Error processing script 'S#[Forecast 2024M4]:O#Forms:A#SalaryWorkdays= S#ForecastInput:O#Forms:A#SalaryWorkdays'." This process is run on a monthly basis, and this is the first time we have encountered this error. We have also tested it in our test environment during the same period and did not encounter any errors. We are unsure of what may be causing this issue and would appreciate any assistance in resolving it.This is the BR: Imports System Imports System.Data Imports System.Data.Common Imports System.IO Imports System.Collections.Generic Imports System.Globalization Imports System.Linq Imports Microsoft.VisualBasic Imports System.Windows.Forms Imports OneStream.Shared.Common Imports OneStream.Shared.W

We use Standard (Calc On The Fly Share and Hierarchy Elimination).  What type of Rule should we leverage to reclass balances from one account to another during consolidation. For illustration purposes, the below is what we are looking at:  

Code: Dim TimeName As String = "2023M1" Dim dt_NIk As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si,"Consol", "E#KY00_Total.Base","OwnerPostAdj",Brapi.Finance.Scenario.GetScenarioType(si,si.WorkflowClusterPk.ScenarioKey).Id,"S#Actual_Hist","T#" & TimeName,"YTD",True,"Flow = 'EndBalanceLoad'",10,False) Error: Error processing data. The item was not found. Entity, Parent, -1.Is there any alternate way to retrieve Data. It works on USD, Local

Api.Data.Calculate(“A#28100=A#69000”) What is wrong with writing a calculation like this? Tips. A#28100 might contain thousands of cells. Calculation MAY work but will damage performance. Defining more dimensions reduces the number of cells that need to be processed. A#28100 = 10 Flow x 1 IC(None) x 3 Origin x 10 UD1 x 20 UD2 x UD3 x UD4 etc Defining more Dimensions reduces the number of cells OneStream has to process. Write the rule as follows: To learn more see GES - Level 2: Financial Model Rules Course Level2-Rules.pdf (hubspotusercontent30.net)    

Hi, I have a Spreadsheet BR that creates a tableview and I want a certain dashboard extender function to be triggered when they submit the data from the tableview(spreadsheet) I think this is the way to go but probably because of the namespace, I cannot do this definition. See the screenshot at the bottom. _______________________ Any help is appreciated            

Hi! I have a business rule which allocates all PL accounts from a group of entities in one segment to other segments. However, I would like to exclude accounts that are IC from the allocation. I have classified the accounts that I would like to exclude with the text "ICElim" in box "Text 8", under "Vary by scenario type & time" in Member Properties, in the account dimension. So, in the following code string, I would like to exclude those accounts. Do you have any suggestions on how to change the code string below so that it excludes these accounts instead of picking all PL accounts?   Dim bIsPL As Boolean = api.Members.IsBase(api.Pov.AccountDim.DimPk, api.Members.GetMemberId(dimtype.Account.id, "PL"), cell.DataBufferCellPk.AccountId)

Hi, I'm trying to retrieve the value of the field "Text - Text 8" for an account dimension member. What formula should I use to get this value? Thank you in advance!

hello, good day; I created a new finance rule calculating the cash flow accounts using as source the balance sheet accounts, the hierarchy is not part of the balance sheet, it's at the same level; when I consolidate or translate the cash flow accounts, the amounts were deleted; but not for Balance accounts. Do I miss something in the finance calc for the data will be durable or something like that? thanks in advence and Best Regards.

Hi - has anyone tried to replicate excel Goal Seek function in Onestream. We have a bonus model calculation in excel which uses excel goal seek and circular reference with iterations options in Excel. We want to replicate it in Onestream. Has anyone done similar excercise.

Hi Everyone. Is there a way to prevent the insertion of duplicate information using that function? Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult() selectionChangedTaskResult.ShowMessageBox = True Try Dim loadResults As New List(Of TableRangeContent) Dim fileInfo As XFFileEx = BRApi.FileSystem.GetFile(si, FileSystemLocation.ApplicationDatabase, strFilePath, True, False, False, SharedConstants.Unknown, Nothing, True) If strFilePath.XFContainsIgnoreCase("xlsx") Then loadResults = BRApi.Utilities.LoadCustomTableUsingExcel(si, SourceDataOriginTypes.FromFileUpload, "Temp.xlsx", fileInfo.XFFile.ContentFileBytes) selectionChangedTaskResult.Message = "File [" & strFilePath & "] Loaded" selectionChangedTaskResult.IsOK = True Else selectionChangedTaskResult.Message = "File [" & strFilePath & "] NOT Loaded" selectionChangedTaskResult.IsOK = False End If 'Delete the temp file If boolDeleteTemp

Howdy, Background: I have a data management job that runs a Business Rule. I have created a dashboard with a button that can trigger this data management step.  Problem: As an Administrator I can run the data management job, or I can click the dashboard button. As a user when attempting to use the button the following error happens: "Summary: Error processing Data Management Step 'xxx'. Unable to execute Business Rule 'yyy'. Object reference not set to an instance of an object." I have read that this is really just a catch all error.  I think I have narrowed the problem down and believe it is because the users do not have permissions on the BatchHarvest Folder (which is referenced in the job).  So, one question I have is: can a Data Managment job be triggered to run "as an admin" that I could assign to the button?

Morning All, I'm working on a new solution to avoid having many, many separate confirmation rules with their own code which is almost identical in each case, and instead move to using a public function so that the similar code is recycled. Seems like a sensible idea! I've got a basic prototype roughly working. So I've created a public function in Finance Business Rules which I am then calling from inside the confirmation rule code. ie. the first code snippet is the public function and the second code snippet is the confirmation rule code calling it. So far, so good and I've proved that the public function is indeed running when I run the confirmation rule (the error log message appears as expected) so I'm pleased so far! What I now want to do is pass in some parameters from each confirmation rule, ie. the only thing that will be different in most cases is which accounts are being checked. So here is where I'm stuck. Within the code that calls the public function I want to be able to pu

Hello, The client has a calculation for the planning process where I used the prior period values in the calculation for current month values. Here is the data buffer I created: Dim OpCostsDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(RemoveZeros(F#Top:O#Top:T#POVPrior1:I#Top:U5#None:U6#None:U7#Top:U8#Top),A#Op_Costs.Base,U1#Top.Base, U2#Top.Base) Then, the client had another idea to accommodate where if the calculation is for first month (M1) take a 3-month average and then for the calculation of the subsequent months (M2 – M12) revert to the original logic of trending on prior month – POVPrior1. I added this logic, where I included an IF statement: Dim OpCostsDataBuffer As DataBuffer = New DataBuffer ()If POVPERIODNUM = 1 Then       OpCostsDataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(RemoveZeros(F#Top:O#Top:T#" & Year1 & "Q4" &":I#Top:U5#None:U6#None:U7#Top:U8#Top),A#Op_Costs.Base,U1#Top.Base, U2#Top.Bas

Hi Community, We have a cubeview that pulls more than 40k records when run for a period in a dashboard. It runs base level for couple of UDs that have ~30k members and 200 members. It renders fairly quickly on dashboard although with paging, but when for exporting the output and running using FDX via DM job (through BR) its taking a lot of time to run. I thought time it takes to run a CV manually should be same when called via Business Rule. Please let me know how can I match the cube view performance when run manually to when I call in a Business Rule. I checked and matched the sparse rows settings both in rows and columns among other checks to match but cannot figure out why it runs slower when i run through business rule.

I'm trying to write a business rule creating a KPI which returns the value of an account for same period previous year. I already have a working business rule creating a KPI which returns the value of the current period which has the following formula:  Return api.Data.GetDataCell("A#38999:T#" & api.Pov.Time.Name &"").CellAmount Where 38999 is the account number for which I want to get values. What formula should I use to, instead of the current period, get the current period but for the same period previous year? Many thanks in advance!

I am trying to save the XML files in the application zip file as separate XML files rather than a single zip. I get the zip file as a byte array and then pass that to XFZip.Unzip The code executes without an error and without any files being saved as well. Does anyone have any suggestions or can point out where I am going wrong with the code?  OnPrem V7.4.2 Dim xmlOptions As New XmlExtractOptions xmlOptions.ExtractAllItems = True Dim folderNameForExtract As String = "XMLs" Dim extractPath As String = $"{Environment.GetEnvironmentVariable ("Temp")}\{folderNameForExtract}\" 'Execute the Metadata Extract Using dbConnFW As DBConnInfo = BRAPi.Database.CreateFrameworkDbConnInfo(si) Using dbConnApp As DBConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si) Dim zippedBytes As Byte() = ApplicationZipFileHelper.Extract(dbConnFW, dbConnApp, Nothing, xmlOptions) XFZip.Unzip(zippedBytes, extractPath) End Using End Using  

Afternoon All, I'm looking to create a set of standardised confirmation rules as Finance Business Rules which I then want to reference from the confirmation rule itself to cut down on maintenance. I'm pretty sure this is possible and I've seen some other discussions but I can't quite figure out the code to use in the confirmation rule to trigger the finance rule. I've seen Dim sharedFinanceBR as New OneStream.BusinessRule.Finance.RulesName.MainClass as an option but this syntax doesn't seem to be available in the confirmation rule code. I think maybe it only works in only business rule types? Is anybody willing to share their code please? (Just the part that triggers a public function from a confirmation rule). Thanks! Richard

Hi, Has anyone had success with viewing the GolfStream reporting formulas such as Return on Assets or Asset Turnover?  I'm trying to learn how to write some ratios and it would be so helpful to view these.  Unfortunately, the formula is greyed out.  Please see below.    

Hi everyone, I'm having trouble logging a databuffer to the error log. I want to be able to do this to debug some code I've written. I got this concept from the Finance Rules and Calculation Handbook so I believe it's possible but I can't get it to work for me! In the first screenshot is the code. The red box shows the logdatabuffer script that I've written. I know there is data in the databuffer because it produces sensible results  (ie. the green box) albeit not quite right, hence why I want to visualise it. The second screenshot shows what I see in the error log. I believe I should be seeing the databuffer results in the orange box area but I just see a blank. Do I need to "switch on" this functionality somehow? What am I doing wrong?!!! Thanks in advance,Richard  

I've got a Tableview embedded in an Excel workbook and would like to be able to prompt the user to select an entity and period that is then used to filter records. Is this possible?

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

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.

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)

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  

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.