Percent Consolidation Behavior
Hi, We are currently attempting to exclude a specific entity from the main consolidation process for reporting purposes. This entity is no longer within scope, but we would like to keep it in its current position in the hierarchy to preserve historical data. We also need to continue importing data into this entity for reporting purposes. Our objective is to set the consolidation percentage to 0% so that it no longer consolidates going forward. After updating the Percent Consolidation to 0%, we are not seeing any impact. The entity continues to consolidate in the application. For context, the Ownership Type is set to Full Consolidation and the Consolidation Algorithm Type is set to Custom. Is this expected behavior? If so would you have any workaround solution ? Thank you for the feedback and help!Solved73Views0likes5CommentsTabbed Dashboard
Hi, I have Dashboard with tabbed embedded reports. for example, MainDashboard - Tab1, Tab2, Tab3. Everything works fine when the user clicks on Tab of their choice for the fiscal year 2026. For Historical data I would like to show the same report for with changed tab. for example, MainDashboard - Tab1, Tab2, Tab4 for the he fiscal year 2025. If the user changes the Scenario from 2026 to 2025 or vice versa the dashboard report tab3/tab4 shows/hide based on FY. How can I achieve at the workflow level? Any help will be appreciated. Thanks.18Views0likes0CommentsHow to read csv file from Documents/users folder?
Hi, I have been trying to read a csv file that is in Documents/Users/userxxxx folder. Not able to make it work. Getting an error. Below is the code Dim FileName As String = args.NameValuePairs.XFGetValue("Param1", String.Empty) Dim sourceFolder As String = $"Documents/Users/{StringHelper.RemoveSystemCharacters(si.UserName,False,False)}" Dim fullPath = sourceFolder & "/" & "abc.csv" Below is the error Could not find file 'P:\Program Files\OneStream Software\OneStreamAppRoot\OneStreamApp\Documents\Users\userxxxx\abc.csv'. Any idea why this is not working? Thank you, Mikki30Views0likes2CommentsFormat - Header Text alignment
Hello, I would like to align vertically and horizontally the text on my column header (in Cube Views and Reports). It seems there is no option to do that in the format parameters (only in Excel). I have tried to use an inline Formula, at least for the Report format, but it is not working. I keep having errors messages. Do you know a solution to get a more consistent presentation ? Thank you in advance, Morgane191Views0likes5CommentsAutomated User Provisioning: Best approach to sync Users & Security Groups?
Hi everyone, We need to automate user creation and security group assignments in OneStream using data from an external Identity system. I have two main questions: Is it feasible to fully automate this without manual intervention? What is the best way to implement it simply (avoiding heavy middleware)? We are considering two solutions: Just-in-Time (JIT) via OIS, and SCIM. Does anyone know how we can set these up? What is the recommended "standard" approach for this? Thanks for your help! Madiha43Views0likes0CommentsCheck details for disk space
Hi guys! I would like to know if there is a way to get a more detailed view of what is consuming disk space for each application within my environment. I understand that the System Diagnostics dashboard provides a report indicating how much space is allocated and how much is being used per application; however, I would like to know if there is a way to obtain a more detailed breakdown per application. Thanks!Solved33Views0likes1CommentExtract Related components for Dashboard
Hi OneStream experts, Lets say a dashboard has 10 components in DEV and in PROD. Added 11th component in DEV and want to move it to PROD by Extract and Load. Is there any easy way to collect all related components of a dashboard? Manually collecting components is painful. What is the best secured way to collecting objects to move it to PROD? Thanks //SureshSolved95Views0likes4CommentsLoad/Extract EventHandler
Hi OneStream experts, I was looking to understand if it's even possible to handle the load button from the Load/Extract section in OneStream using a specific EventHandlers of any kind. I need to be able to add validations whenever a Metadata xml file is loaded through the Load/Extract to check certain things of its content without falling (as usual) in a custom development from scratch. Hopefully someone is able to assist. Thank you!38Views0likes1Comment