Tag:"system" | OneStream Community

Error saving a data buffer in Custom Calculate
Hi Community, I try to save a simple data buffer within a Custom Calculate and receive a cryptic error message. Dim sourceDataBuffer1 As New DataBuffer sourceDataBuffer1 = api.Data.GetDataBufferUsingFormula("FilterMembers(C#Local,UD8#None)") sourceDataBuffer1.LogDataBuffer(api,"sourceDataBuffer1",100) Dim resultDataBuffer1 As DataBuffer = New DataBuffer() For Each cell As DataBufferCell In sourceDataBuffer1.DataBufferCells.Values Dim sCell As New DataBufferCell(cell) api.LogMessage(sCell.DataBufferCellPk.GetMemberScript(api)) resultDataBuffer1.SetCell(api.SI, sCell, True) Exit For Next resultDataBuffer1.LogDataBuffer(api,"resultDataBuffer1",100) api.Data.SetDataBuffer(resultDataBuffer1, api.Data.GetExpressionDestinationInfo(String.Empty)) When I start the Custom Calculate from data management, I select a base entity and C#Local, scenario and time. The code will write a log with an usual POV of the cell without common members (line 7) and also log the restultdatabuffer1 with 1 cell (line 11). But running into line 12 will cause the error. Summary and description only show "Error processing script ''." without further details. Summary: Error processing script ''. ---------------------------------------- Description: Error processing script ''. [...] ---------------------------------------- Exception Type: XFException Thread Id: 249 Message: Error processing script ''. Source code: line 0, method SetDataBuffer ---------------------------------------- Exception Type: XFException Thread Id: 249 Source code: line 0, method SetDataBuffer ---------------------------------------- Exception Type: XFException Thread Id: 249 Source code: line 0, method SetDataCells ---------------------------------------- Exception Type: XFException Thread Id: 249 Source code: line 0, method SetDataCell ---------------------------------------- Exception Type: XFException Thread Id: 249 Source code: line 0, method SetData ---------------------------------------- Exception Type: XFException Thread Id: 249 Source code: line 0, method DetermineInputView Within a regular calculation script, the data buffer will be saved correctly. Any idea what the issues could be? Thanks, Marcus
Solved
Marcus
10 days ago Place Rules
55Views
0likes
4Comments
Short cuts in the business rules editor?
Hi all Are there any key short cuts in the business rules editor? Cheers
Solved
ChristianW
16 days ago Place Rules
6KViews
0likes
7Comments
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?
snouri
2 months ago Place Rules
180Views
0likes
3Comments
Send Email - Attach files from File Explorer
I'm attempting to send an email with an attachment from a file stored in FileExplorer. What does my file path look like if the file is saved in File Explorer->Application Database->Documents ->Public? Regards, Anusha
Solved
Anusha_MP
2 months ago Place Rules
3.8KViews
0likes
7Comments
Is 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?
ErickTr
3 months ago Place Rules
504Views
0likes
3Comments
Performance 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.
Solved
GajendraS
3 months ago Place Rules
1.5KViews
0likes
10Comments
GitHub/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.
Solved
liyinan357
3 months ago Place Rules
1.3KViews
1like
12Comments
Extract_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. Tom
Solved
Tom
4 months ago Place Rules
384Views
0likes
2Comments
how 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 Using
Marco
4 months ago Place Rules
722Views
0likes
4Comments
Member 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 Marcus
Solved
MarcusH
5 months ago Place Rules
745Views
0likes
4Comments