OneStream Platform Forums

We have been running several tests on DM jobs to upload batch files through the Harvest. We have a lot of subfolders created that we don't need anymore. Is there any way to delete? Thanks!

Hi,I need to check in a Table View if certain column values are dirty and I've noticed that when you call the IsDirty() function on any decimal type column (and this only happens on that type), it always returns 'true' even though no changes took place.Because of this i need to manually parse the value and check if the originalValue is different from the current value.At this point I was wondering if this behaviour is intended or not, it seems odd that IsDirty() returns the correct value for every type of value BUT a decimal one.Any clarification on this matter is appreciated, thanks in advance. 🙂

Do we have any way of restricting the Unbalanced Journals in OneStream? I read about the Journal Event Handler but don't see that BR in my application. 

hi experts. i'm trying to use a button on dashboard that calls a DM sequence. in my sequence, i'm calling copy task. Basically, i'm trying to copy data using DM step where i want to pass scenario as parameter. here is the configuration. How to pass parameter to copy task from sequence?    button configuration: Sequence - parameter definition  copy step:  

Hi, I am trying to explore the FDXExecuteStageTargetTimePivot if I can use it to show stage data. Does anyone have the business rule and shareThank you

Hello,  Is there any Intercompany Report set up training and/or documentation with examples of report detail for the different Intercompany Reports on the Application Reports dashboard?  Thanks!  

I want to load OneStream application data to external database. And there is an existing connection to the target external database. But it gives me below error, could you please help? No idea what is wrong. BTW, "FDH_DEV" is SIC external database connection.   'Build a data table with one test line Dim TestTbl As New DataTable TestTbl.Columns.Add("Tmt", Type.GetType("System.String")) TestTbl.Columns.Add("SEnt", Type.GetType("System.String")) TestTbl.Columns.Add("TEnt", Type.GetType("System.String")) TestTbl.Columns.Add("SAct", Type.GetType("System.String")) TestTbl.Columns.Add("SActD", Type.GetType("System.String")) TestTbl.Columns.Add("TAct", Type.GetType("System.String")) TestTbl.Columns.Add("TActD", Type.GetType("System.String")) TestTbl.Columns.Add("SFlw", Type.GetType("System.String")) TestTbl.Columns.Add("TFlw", Type.GetType("System.String")) TestTbl.Columns.Add("SIc", Type.GetType("System.String")) TestTbl.Columns.Add("TIc", Type.GetType("System.String")) TestTbl.Columns.

I am writing a simple api.data.calculate code in C#. Somehow it is not able to recognize Durable data "true" but it does work vb.    

I have an issue that I have seen before I never figured out so want to see if others have encountered this and figure out what I am doing wrong.  I have a data adapter that calls a Dashboard Dataset BR to get populated.  I pass in a parameter like "Parameter1=|!SomeOtherParam!|".  When I use "args.NameValuePairs.XFGetValue" to get the Parameter1 value is returns "|!SomeOtherParam!|".  I expect to see the actual value of SomeOtherParam or nothing but not the literal param with pipe and exclamation mark.  Has anything encountered something like this before?

Hello,I am currently working on the Business Rule WorkflowEventHandler to update a custom table when certain tasks are manually completed in a workflow. The scripts shown in the screenshot are located in the section where Case Is = BREventOperationType.Workflow.UpdateWorkflowStatus, with the following condition: If NOT args.IsBeforeEvent Then.I want to trigger the function after the current workflow is fully completed. However, despite testing various syntax alternatives, the function consistently executes before the workflow is fully completed.For example, when I initiate the last step of the current workflow, the function is always triggered at line 141. For context, this issue occurs when the workflows consist of multiple tasks. The final task varies depending on the workflow—it may end with Import, Confirm, or another task.Below are the syntaxes I tested but without success.Could you please help me resolve this issue?Thanks 

Recently we upgraded to 8.5 and I found the back/forward buttons missing from the top left corner of the screen. We jumped a few versions so not sure when this was removed. Can anyone tell me when this happened? I cannot find anything in the release notes. I have some dashboards built to use this back button so I will have to update them.

Hi,I need to use inside my Table View service some parameters that are bound to combo boxes in order to write a query, and execute it when the "SaveTableView" function is called. Unlike the "GetTableView" function, SaveTableView's signature doesn't provide a parameter that contains all substitution variables (Dictionary<string, string> customSubstVars for GetTableView)I also tried setting the customSubstVars dictionary into the BRGlobals from the GetTableView function, but once you try getting the dictionary from the globals, it returns null.Is there no way of getting this customSubstVars dictionary to use it inside SaveTableView?

Wondering how we can zero-out the translated FX noise in a local (Euro) base entity that has the accumulated FX noise showing up in USD after the entity has all of its local currency balances zeroed out.   We have some adjustment USD sibling entities to this Euro entity in question but entering an offset in that entity does not remove the translated USD amount.  If we set the properties to Is Consolidated = False, would this completely remove that entity from consolidated history (if we were ever to go back and reconsolidate the system)? Has anybody encountered this and what did they do? Thanks. Mike B

Hi, I have set all security settings on an entity to "Nobody" and yet when I see a dashboard using a non-admin user I still see data. The same when using a spreadsheet. This does not make sense to me. What am I missing? 

Hello, I have a defined a dynamic dashboard based on an SQL table component. The goal is to create dynamic dashboards based on this table. In the last column of this dashboard, I have a parameter which drives a selection based on 2 values: Manual, Predictive. My dynamic dashboard run as expected except for the last part, which I would like to have as a Radio Button Selection and should reflect what is defined in the table.     My question is : is there a way to define what would be the selection of the radio button based on a dynamic dashboard business rule ? Regards,

Hi all, Could you please advise what formula is better to use in cube views member filter, when I need to add column with calculated differences between U1 base member at time POV and the same UD1 base member at time PovPriorYear?  

Rolling Quarterly Forecasts- to Import 12-month flat files- Several times daily during a cycle- 12-month Matrix Data Source 1. Forecast Q1 '25 flat file- Columns Q1-Q4 '25 = amounts 2. Forecast Q2 '25 flat filea. Columns Q1 '25 = blanksb. Columns Q2-Q4 '25 = amountsc. Q1 '25 to be refilled with actuals- using a DM Job after the initial Import 3. Forecast Q2 '25 flat file - Columns Q1 '25 = blanksa. Direct Import/Load- Wiped out refilled actuals in Q1 '25 = blanksb. Standard Import (Import, Validate, Load)- Kept refilled actuals in Q1 '25 4. Blank Columns - Q1 '25, etc = Prior Periodsa. Why do Direct and Standard process blank columns differently?b. How to make Direct process blank columns like Standard?- Keep actuals in Q1 '25/prior periods in OS Data Cubes TY.

I'm using attribute members, unfortunately on the entity dimension, so the associated data is stored and not dynamically calculated on Parent Entities. These attributes members do not translate to foreign currencies during the consolidation process ! I'm using a 'Custom Translation', and when I execute the method 'Api.Data.Calculate()' or 'Api.Data.CalculateForTranslation()' the attribute cells do not translate.The only way I was able to actually convert them is by using Data Buffers and forcing the conversion.Is there a reason why ADC methods do not translate attributes ? Is there a hidden property to activate in order to take these members into account ? Should I use 'Api.Data.Translate()' instead of ADC ?Thanks

I would like to return a sum of all rows in my cube view but using the 'sum of rows' is only returning the first result for every account under the main hierarchies I'm calling. This is the literal statement I would like to sum -GetDataCell(A#BALANCE_SHEET.Base.Remove(A#32000).Where(AccountType DoesNotContain 'Liability') - A#BALANCE_SHEET.Base.Remove(A#32000).Where(AccountType = 'Liability') - A#32000:F#BegBal - A#INCOME_STATEMENT.Base.Where(AccountType = 'Revenue') + A#INCOME_STATEMENT.Base.Where(AccountType DoesNotContain 'Revenue'))Has anyone done something similar through an XFBR string? 

Dear all, Could you please advise what type of scenario is better to use for FastClose (first version of actual financial statement numbers, which we want to keep separately)?  

I am trying to create a label which needs to display the gross profit in my dashboard. I have created a data adapter (when running the adapter, it's showing the relevant data) and attached the same in the label. But I am not getting any data in label. Can someone help/suggest what I am missing? 

Hi, I was wondering if anyone knew how to get an extracted list of all artifacts within an environment by artifact types such as business rules, transformation rules, cube view names. I am only interested in getting the names/metadata of each artifact and not the actual data from the artifact. I would like to put these in an excel workbook.  Thanks! Manuel

I have a home page that has a button that takes you to guided reporting. I want it to use guided reporting where the user left off - how it works when you are normally in guided reporting alone. When I click the button it keeps setting Guided Reporting back to having the choose the report group. Is there a step I'm missing when linking guided reporting to a home page?  

I've heard about org by period since my first exposure to OneStream but I see nothing in the docs and no clear discussion about how it works or what the limitations/requirements are. Where does this information live?

I am trying to build a cubeview wherein if i select actual scenario the comparative scenario come Budget Forecast and PY whereas if i select my comparison scenario is PY Fcst or PY. Is there a way with any business rule if i can do?