OneStream Platform Forums

Hi team! I'm utilizing the "process cube" function within a JournalsEventHandler. However, whenever the event occurs after the journal is unposted, the process cube fails to execute; it gets stuck and never completes. if the event occurs after the journal is posted, it functions correctly. Not sure what is causing it. here is the piece of code: Else If (args.IsBeforeEvent = False) And _ (args.OperationName.Equals(BREventOperationType.Journals.PostJournal) Or _ args.OperationName.Equals(BREventOperationType.Journals.UnpostJournal)) BRApi.DataQuality.Process.ExecuteProcessCube(si, _ BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, _ EntityWFName, WFScenario, WFTime), _ StepClassificationTypes.ProcessCube, _ False) End If Thanks.  

Hi Everyone, I am trying to allocate forecast data to the gl's based on the last year actuals data. The allocation is not happening when the forecast scenario setting "clear calculated data during calc" is set to TRUE. If I set it as FALSE, the allocation is happening. This data is copied using the setdatacell from the allocated value to the target script in which origin member is O#forms.  It seems the value is not written to the origin member if I set the scenario setting to true. can someone explain me what is happening? Also, I tried adding the below calculate and clear code.  api.data.calculate($"{script} = 0 * {script}") api.data.clearcalculateddata(script) It worked until I did not change any data, once I changed the data, the allocation did not happen again.     Thanks, Jeevan  

Dear CommunityI am facing the fact that my XFBR(BR_XFBR_String, ParentBold, sEntity = |MFEntity|) does not passing the Entity Name to XFBR.CubeView is organized in the way that Rows contains just a part of Entity structure Entity.ChildrenInclusiveR (this two step structure has no Base Members) and i need to format only Top Parent of that. It works when Variable comes form POV or CV but not from the Rows/MF.Is there any way to use |MF...| for passing information to XFBR?Thanks

Hello community can the Grand Total be added at the top instead of the bottom?   thank you a lot  

The Function in my rule : Brapi.Utilities.ExecuteDatamanagementSequence run the sequence in Background and allows me to do further operation in BR even before the step is complete.Is this the expected behavior?How do we avoid this. To run further operation until the complete sequence is complete?  

Hi everyone, Is there any possibility to display a message box when there is an Fail task during import a file? I am launching automatically an Import Validate Load of a file when the user import mannualy a file from a specific workflow task, and I would need to display a feedback when one of these tasks is Fail (wrong intersection for instance) ? Many thanks for the help, Aurélien

Hi everybody, I'm currently developing a dynamic CV that gives the chance to the user to select an account hierarchy of choice to show in the report  (P&L, BS etc.) through the parameter MainFormParentAcc_PL I'm having issues with indentation tho, because if I add .TreeDescendants the accounts are still shown on the same level in the report.  I tried to look if there is a format I can apply, but if I understand correctly the only format available for indentation is for the excel view (ExcelIndentLevel = xxx). Do you have any suggestion on how I could solve this?Thanks in advance!

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

Hello People, I built this CV and then I'm building this BI I used the same CV above in the BI dashboard, however, I couldn't move the periods in the columns like in the CV. I would like to have the periods in the columns like in the CV to get the same data.do you have guys any examples of this?    thank you

I need to run consolidation from WF using the calculation definition upto the immediate parent of each entity level WF. what would the step to do that?

Is there a way to configure the system so that it will check if a consolidation is already running before allowing another user to start a consolidation?  If so, how do we configure the system to do this?

Hello, I was wondering if we can have forms only populate for certain months. I tried using the Form Frequency filter as Member Filter and tried a few different things to no prevail. I only need the form to show up in the WF for months 1-10 and I tried T#WFYear.Prior10 and a couple others. Thanks, Will 

Hello good afternoon, I need to extract a specific hierarchy without extracting all the hierarchies we have in the account dimension, as you can see in the next screenshot, I just need TP9E in order to extract and import into a different app: But when clicking into the application load/extract (metadata) I see only options to extract the hole dimension: Is this possible? Many thanks in advance.  

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:  

Hi everyone,                   I want some help in workflow.anybody knows how to get warning action during importing of data in workflow using conformation rules.If someone know please help me.                  Otherwise,you can tell any alternative method to achive this case like through the business rule(parser).The business rule should give the warning message at workflow import process(first step of loading data) and the importing process should me continued,not to be breaked.i.e)soft validating......we want warning action not error action.Thank you.

Hi all, I am trying to build out a CV for a report and I'm having trouble with the best way to build out the columns. My current approach is to just go at each column with differing member filters. For Example: 1st column - S#Actual:V#MTD:UD#Orders:...etc. Does anyone have a better approach that I could use? Or even just point me in the right direction in the documentation? Thanks in advance! Here is a screenshot of the report columns I need to build in OS:  

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

Dear Community, I have a requirement to generate a pop-up or warning message during the Data import process based on a specific condition. If the condition is met, the pop-up should inform the user, but the import process should continue without causing a hard fail. Is this achievable ? Can anyone please suggest a method to achieve this. Thank you.      

Dear community, I currently have a Business Rule connector that works fine. However, I would like to pass a parameter from a dashboard into the SQL query of the connector. This is because the user should load a set of data but they can decide which "slice" of data to use. Hence, the connector should filter the data, and then I need to pass an input parameter to my SQL query within my connector. Any possible way to do that ? Regards,

Dear Team, I'm trying to understand what caused the low performance of my code. I see that it's because of many loops, but I'm wondering if there's any possible way to fix it: Dim ResultDataBuffer As DataBuffer = New DataBuffer() Dim sAccounts As List(Of String) = New List(Of String) From { "1711050", "2742020", "1712020", "2745060", "1346010", "2413010", "1742050", "2716050", "1745010", "2713010", "3221010", "3221020", "3221030", "4451010", "4451020", "4451030", "1722060", "2741030", "4541070", "4321020", "4541010", "4541020", "3222010", "4452010", "4541030", "4541040", "4541050", "4541060", "5111010", "5111020"} Dim mICFilter As List (Of Member) = api.Members.GetBaseMembers(api.Pov.EntityDim.DimPk,api.Members.GetMemberId(dimtype.

We load the GL data with YTD View. Data was loaded for 2024M2. There is no data loaded for 2024M3. For some reason after the consolidation/Force consolidation is run for 2024M3, the M3 P&L accounts are appears to reverse the M1 and M2. I do not expect to see any numbers for M3 and we haven't loaded any data for M3. It appears, I am missing something.  

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 all,  I try to paste new records to SQL Table Editor from Excel spreadsheet. It allows me to paste the data, it seems right, but it does not allow me to save it. It behaves like there is no data at all. What am I doing wrong? Thank you!

Hello,  I'm hoping someone can help me with a syntax issue where I have data in a spreadsheet that is organized with accounts on the rows and 12 periodic months in the columns. I want to be able to tell OneStream that there are multiple amount columns and columns represent different time periods. I can label the amount in the 1st column "Jan" and make T#:[2024M1] using XFD named range the data will load but I want to be able to load all twelve columns at once. Does anyone know how to do this? Does it require a business rule? Thanks,  Scott