OneStream Platform Forums

Hello, I have this strange situation where information was entered with form input and for 1 of the entities the data disappeared on several accounts. This is in a scenario type1 scenario.  When information is entered again the old values can be found with Audit history for Forms from the drilldown. Any idea how this can happen, I would expect it only after a reset scenario, but that would remove also data for other entities, could also be by removing the entries, but there are several different forms, so that seems unlikely. kind regards Ben 

After upgrading to v8, we seem to have lost the comma formatting that was there on the standard IC Matching Partner Detail report.   Is this something that I can change, and if so will I need to do this anytime there's an upgrade?  I can't find where this setting resides.    

Today, a customer asked me:  Where do stored calculations store data?  api.Data.Calculate If Statements  In stored calculations, If Statements are helpful to specify that a formula is only required to execute on specific Data Units, as shown in the image below.   If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyForEntity())) contains two logical operators (And and Not). Due to the AND operator, the statement api.Data.Calculate("S#Forecast = S#Actual") between Then and End If will only run if both of the following are true: The Entity is a Base-level Entity Member, i.e.: does NOT have Children (Not api.Entity.HasChildren()) The Consolidation Member is Local indicating the Entity Member's local currency (api.Cons.IsLocalCurrencyForEntity()) The statement api.Data.Calculate("S#Forecast = S#Actual") will copy the S#Actual data buffer to the S#Forecast data buffer. The If...End If

Hi community, Does anyone have a good member formula for calculating income/equity attributable to minority interest on the P&L and balance sheet? My understanding is in our case we can report this in a simple manner with just two additional accounts, one on the P&L and one on the balance sheet. In my mind the P&L account would work something like the following, if ownership type equals Non-Controlling Interest then multiply net income by (1 - percent ownership). I'm currently trying the below formula for the P&L account, but not yielding any results. After running a consolidation there is no data in the new account. Any suggestions on how to solve this? Thanks, Dim dValue As Decimal = api.Entity.PercentOwnership() Dim objOwnershipType As OwnershipType = api.Entity.OwnershipType() If objOwnershipType = "Non-Controlling Interest" Then api.Data.Calculate("A#NCI_Income:I#None:F#PL_LOAD:O#Import:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#Data_Load:U8#None = A#NetI

Hello, I have a dynamic calc UD8 member, where I put small value grater then 0 (0.00001) to be able to display certain rown even when the initial value is 0. This works with FormulaPass, but does not seem to work with dynamic calc. Does anyone know if there could be a problem that dynamic calc values get supressed when all CV supressions are set to "True"? Thank you!

Hi! we are facing Corporate Sustainability Reporting Directive in Europe, and we need to report in XBRL format since the 1st jan 2026. we are looking for solutions on how to report in this format from Onestream. Is there some tool / connector you may know that can be applied? Do you have any recommendations on the architecture to do that? Thank you!

What is the correct syntax for the filter expression in the DataUnit method command used in BRAPi.Database.ExecuteMethodCommand()?We are trying to filter on Flow member EndBal.  The following syntax does not work:MethodQuery: {FinRpt}{CorpEntity}{}{}{ACTUAL}{2024M1}{YTD}{True}{F#EndBal} results in the follwoing error:The expression contains invalid date constant '#End_Inp'.MethodQuery: {FinRpt}{CorpEntity}{}{}{ACTUAL}{2024M1}{YTD}{True}{WHERE Flow LIKE '%EndBal%'} results in the follwoing error:Syntax error: Missing operand after 'Flow' operator.{WHERE Flow = 'EndBal'}, {WHERE Flow IS 'EndBal'}, and other variations all result in the same syntax error. 

Is there a way to see the current OS license that is installed?  We have recently had the number of user licences increased and now want to check that this has been applied, I'd hoped this would be in an obvious place like the environment or security but can't see anything that shows the current license (just being able to see the number of enabled users that the license allows would be a good start).

Is there a way to set the task manager to automatically read the calendar for the upcoming months? And assign the Work Days so the client don't need to have to load them manually in the system?

Has anyone had issue with OneStream after switching to Windows 11?

Hello We are trying to build a CV where we need two parameter selections by the user. The first parameter selection needs to be passed into the second parameter. The second parameter is configured as a bound list using Method Type as Business Rule, and the first parameter selection needs to be passed as an argument in the Method Query - but the BR is not able to resolve the parameter value and is only able to read it literally. Following configuration is for the second parameter The BR is reading t1 as "|!TestingPrompt1!|" and not the actual parameter value that was selected by the user. Any ideas on how to solve this are appreciated. Thanks!  

Hi I have a form and there is a balance sheet account, total input and validation columns. The condition is to check if the balance sheet account value has a value and total input has no value, if balance sheet account is 0 and total input has a value and total input is greater than balance sheet then validation should be 0. If balance sheet is greater  then total input then validation is 1. This validation is stored in a member formula and I was wondering how can I get the validation column to show 1 or 0 based on the conditionI have tried the SetDataCell() first but found out that on a member formula that does not work, which other function can be used. Your assistance will be greatly appreciatedRegards 

We have created a set of confirmation rules for our forms. However, there is a company that is failing the rule because of an adjustment that must be made by recommendation of the auditors but would not otherwise be accepted. Is there a way to exclude just this company from the rule?

Hello OneStream community,  Since we've updated to PV710-SV202, the export of inventory list only has GroupID, which is less user friendly compare to GroupName. Has any one get any luck with getting GroupName included in the export?  Thanks! 

Hi I have two source accounts bringing in same amounts for multiple Entities. Some of the entities are local and some overseas. The only unique identifier is Text7 field in the entities. How can I map the source accounts to OS accounts using Entity Text Field 7. Below is the example Acc 1000 - $7000 E#AUS Acc 2000 - $7000 E#AUS Acc 1000 - $9000 E#NZ Acc 2000 - $9000 E#NZ In the above example Amount $7000 belongs to local Entity so should be mapped to A#Local_Tax and Amount $9000 belongs to overseas Entity so should be mapped to A#Overseas_Tax. The problem is in the import file the amounts 7k and 9K sit in both local accounts Acc 1000 and Acc 2000. The only unique identifier is the Text 7 value in the Entity. Please advise if I can use this text value in Composite Transformation rule or if I need a complex business rule. Any suggestions are welcome,  Thanks Sam

Looking into a way to turn off translation for specific entities, yet only for the budget scenario and select gain/loss accounts. Having translation on for Other Expense and Net Income as it relates to budgeting is skewing the EBIT bottom line. Is turning translation on a budget scenario and specific Entities possible? Thanks in advance, 

All,  We currently have a combo box (with entities) in a dashboard but we would like to make this list a bit smaller and based on the security rights a users has. I want to solve this with a XFBR which i afterwards attach to a parameter and that parameter in a combo box. Does somebody has an example of this XFBR code which i can look into? Or is there a better way to do this.   Thanks

Hello - I have a cube view that's linked to another to show detail. I have bound parameters set on the time, view and account dimensions. These parameters are all working properly except for the calculated column I have in the main/parent CV - its a column that has a GetDataCell expression. When I right click and select "Navigate to Entity Drill" on a cell in this column, the account and view members are still correct, however the time period its passing through to the linked CV is incorrect. The time member it passes through to the linked CV is the period of the first column in the main CV. So for example, the time period of the first column is 2024M4 while the period for the GetDataCell column is 2024M8 - the linked CV will show 2024M4 even though the Cell POV shows 2024M8. How can I send the correct time period to the linked CV on this GetDataCell column?

Hello, I am creating a dashboard with a grid view and gridview is binded to a Data Adapter which calls a business rule to get data thru an external web-api call. Now I have to show data in Gridview and the record count on the dashboard on a button click. I have used following settings on the button. The Selection changed server task is happening first and then the data load is happening, so I am able to update the literal parameters with counts after data load but they are not reflecting on the dash board. Any help appreciated.

Hello Team  I am currently using the "FDXExportDataUnit" function to load data into a DataTable using the following code: Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si,"FPA_CM","E#Entity_top.base","USD",scenarioTID,Scenario,timefilter,"MTD",True,"Amount <> 0 And Flow='EB'",16,False)   he resulting DataTable contains 678,123 records. I plan to insert these records into a Snowflake database. To speed up the inserts, I am dividing the DataTable into multiple DataTables of 150,000 records each. However, the inserts are currently happening sequentially, and I want to run them in parallel. I am considering the following options: Pass the split DataTable as a parameter to a Data Management sequence:This would allow me to call the sequence using "QueueDataManagementSequence" so the process runs on different servers. I need assistance on how to pass the DataTable as a parameter to the sequence. Run bulk insert SQL statements in parallel using threading tasks:

I have a csv file that has two columns one for Debits and the other for Credits columns E and F (5 and 6).  I'm using the code to take the Debit column if there is a number in Col E use it, if zero, take number from Col F instead. In the Data Sources settings in order for the script to work properly I need zero suppression to be False or it won't pick up the credit column. Note in the script that integer = 5 is referring to column 6. Is there a way to suppress zero after the script runs or write zero suppress into the script?  Thanks Scott

Hello, I am trying to create a Dashboard with several cubeviews in it. I created a delimited list parameter with different categories of cubeviews. Does anyone know how to assign the cubeviews to the different display items?For examples, I will have a category "Sales" and when the user will select "Sales" in the drop-down menu, I want certain cubeviews to be displayed in my dashboard. thank you!!

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?

Hello,      I am having trouble with a selection screen on a Dashboard where items are moved from one ListBox to another. It is a multiselect=True but how can we have the items selected on the 2nd list box. I have to read this list in a BR but until and unless they are selected the item is not passed to the BR for further processing. Any help would be appreciated. Thank You, Indu

Hello,There is this grid view property that has been bugging me for a while called 'Show Row Headers'. Using VB.Net, we cannot define 'Headers' for the rows of a DataTable object, so I'm curious to know how to use this property to the fullest ?By switching it to 'False', the only noticeable difference is this little blue arrow that disappears: I assume that we can have a CubeView-like formatting with Row & Column headers using the grid view, but I can't seem to enable it.Thanks for your help.