cashflow statement : Condition in the mapping of accounts
Hello OS community, I am currently developing my Cash Flow Statement and I want to add a condition for a loan account. If it has a positive balance in the Working Capital Requirement variation flow, I want to map it under one CFS table. However, if it has a negative balance, I want to map it under a different CFS table. How can I implement this condition in my Cash Flow Statement?179Views0likes3CommentsIs that posible to export Task Activity or Error Logs with business rule?
Hi Team, I am wondering is that posible to export Error Logs or Task Activity with business rule? I know we can extract data from cubes or dimensions using BRApi methods, but is there a similar approach that allows us to export Error Logs or Task Activity? If so, what methods or steps are needed to achieve this?503Views0likes3CommentsPerformance issue with Cubeview
Hi Team, I need to parameterize my Cubeview where I need to sum two flow member data and show it in my Cubeview , For which i need to write a rule in that rule I have to create a temporary variable member (Total) which doesn't exist in our flow hierarchy which will contain sum of our flow member (RFX_Input + UFX_Input) data, and this Total variable member we have to parameterize and so that when Cubeview runs it'll show me the total value of (RFX_input + UFX_input) into my Cubeview. Please help me to guide how to write this rule logic. We have tried creating it as a parameter with getcelldata but the cubeview does not render and timesout.Solved1.5KViews0likes10CommentsGitHub/OneStream Integration
Does anyone have experience leveraging GitHub or any other code version control tool to manage Business Rules with OneStream? Assuming we have a remote Git repository on GitHub that keep track of all of our business rules. How do we push the code from remote repository to OneStream? Or in other words how do we run git command to push/pull. In this context, we want to assume there is file system on cloud store all the business rules in file format. If there is no file system on OneStream, how are the Business Rules managed on cloud? Any pointers will be appreciated. We found a way to update the Business Rule table: xml_data in Application Database. But we are seeking for better options.Solved1.3KViews1like12CommentsExtract_Data_System
I can extract data by using SQL in the System and Application Tables, but I don't know how to extract the Data from the System Tab -> Logging -> Logon Activity, Task Activity or Error Log. If I choose right click and export, then I just get the current screen. Thanks in advance of any help / suggestions. TomSolved383Views0likes2Commentshow DataBufferCellPk works in this segment
Hi Everyone. I would appreciate some help in understanding how the DataBufferCellPk works in the following code, and in general. I’m currently reviewing a business rule where entities are charged to others—essentially an allocation. However, I haven't found any use of CALCULATE or similar functions that would typically handle this process. This leads me to believe that DataBufferCellPk might be responsible for it. Could you please assist me in understanding this better and provide more context on the issue I'm trying to resolve? Dim dbcpk As New DataBufferCellPk( mbrRefIdAcc, mbrRefIdFlow, intOriginId, mbrRefIdIC, mbrRefIdUd1, mbrRefIdUd2, mbrRefIdUd3, mbrRefIdUd4, mbrRefIdUd5, mbrRefIdUd6, mbrRefIdUd7, mbrRefIdUd8 ) 'BRApi.ErrorLog.LogMessage(si,$"Valores de DataBufferCellPk 2023M3: MbrRefIdAcc: {mbrRefIdAcc}, MbrRefIdFlow: {mbrRefIdFlow}, IntOriginId: {intOriginId}, MbrRefIdIC: {mbrRefIdIC}, MbrRefIdUd1: {mbrRefIdUd1}, MbrRefIdUd2: {mbrRefIdUd2}, MbrRefIdUd3: {mbrRefIdUd3}, MbrRefIdUd4: {mbrRefIdUd4}, MbrRefIdUd5: {mbrRefIdUd5}, MbrRefIdUd6: {mbrRefIdUd6}, MbrRefIdUd7: {mbrRefIdUd7}, MbrRefIdUd8: {mbrRefIdUd8}") 'BRApi.ErrorLog.LogMessage(si,"Parameters bufferdatacell 46: " & dupk.ToString & " * " & intViewId.ToString) Using dbConnFW As DBConnInfo = BRApi.Database.CreateFrameworkDbConnInfo(si) Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) listDc = BRApi.Finance.Data.GetDataBufferDataCells(dbConnFW, dbConnApp, dupk, intViewId, dbcpk, False, True) End Using End Using709Views0likes4CommentsMember Formula - get current member name
Hi All Does anyone know if you can get the current member name in a Member Formula? As an example, I have the UD8 member UD8AverageRate_Budget - I want that information without manually adding a variable. I have a lot of members whose member names contain all the information for their value. It would save me a lot of time if I had one script that I could copy to all the members without editing them to update the member name. The members are DynamicCalc if that makes a difference. I have triedargs.DataCellArgs.FunctionName andargs.CustomCalculateArgs.FunctionName but they both raise an error. Thanks MarcusSolved732Views0likes4CommentsAssessed Loss utilised in current year - Tax
Hi, anyone has worked with a similar member script or rule that has a conditions - egassessed loss utilised in the current year is based on higher of $1 million and 80% of Current Taxable Income account. This is limited to the assessed loss carried forward account (Assessed loss carried forward is assessed loss bough forward, less assessed loss utilised in the current year).405Views0likes3CommentsFcst - Copy of Actuals into Locked/Certified Fcst scenario via BR
We have a job that leverages the Global Time and Scenario to copy Actuals over into our Fcst Scenario. My question is around the ability of a BR to change data in a certified scenario. From what we are finding, even if we certify the Fcst Scenario, when the rule runs and the Global period has not changed, the BR copies/updates the Fcst period with Actuals. Part of the problem is that sometimes we have to move the period forward for our operational folks while we are still working on Fcst so the Global Fcst scenario stays the same but the period get moved. This then creates a situation where our DM jobs update the current period (Import Origin) with $$ which throws off our Fcst. My question is: Is there a systematic way to prevent this or do I need to add logic in my BR to check the status of something (note: this copy is not tied to any WF's, just a general copy this to that). Goal is that once we certify our Fcst WF's (Entities are tied to these WF's), nothing should be changed.Solved337Views0likes1Comment