Application Build

Hi everyone,Does anyone know if there is a way to encrypt tables in the Application DB? if yes, how?Thank you for the help!

Hi, For the folks that already did the upgrade from v8 to v9, how was the process and timeline.  Not looking for detailed steps but high level.  Thank you in advance, Praveen

Hi everyone,I am currently using the metadata builder in excel to maintain and keep updated the hierarchies of all dimensions, but I'm having an issue in loading two separate dimensions for UD5.I was planning to build the U5 dimensions as follows:within each dimension, I would have the same base members organized in different hierarchical structures (aka same base members but different nodes between Finance and HR). In Excel, I divided the two dimensions in two separate sheets, because I can reference one dimension at a time in each sheetwhen I load the XML of the first dimension, I have no issues and the dimension loads as expected. If I make a change to the configuration of that same dimension and load the new xml, I still get no issues.The problem arises when I try to load the XML of the second dimension. The error I get is the following:Error processing XML file type 'Metadata'.Error processing XML.The specified member does not belong to the encompassing dimension. 169989, Cos

Our team would like an enhancement to the Web version of the client (Version 9.0.0) as the Modern Browser Experience does not allow us to use the default pivot grid views we created. The default pivot grid views we created work great in the Desktop version, but they do not work for our Browser version because we exceed the number of allowed default fields. This enhancement would allow our users to save time with the ability to use default views, instead of needing to add in the fields manually each time.

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.        

Hi,How can I store data in a cube view cell that comes from a business rule linked via a DM stepI want this cell to become 75, if I input 50 on the white cell.Is this related to a cube view property or a business rule? 

Hi everyone,We are currently developing a planning solution in OneStream for a client who has requested that the Cost Center dimension (and its related nodes) be updateable every year, while still maintaining full retroactivity when users need to view reports for prior years.We have considered two possible approaches:OPTION 1Each year, load a new Cost Center hierarchy associated only with that specific year. When users want to analyze historical data, they simply select the hierarchy corresponding to the year they are reviewing.The main drawback of this approach is that, over time, multiple versions of the Cost Center hierarchy will accumulate, which could potentially impact maintainability or performance in the long term.OPTION 2Separate Cost Centers and their nodes into two distinct dimensions. Introduce a technical member in the Account dimension and use a data entry form (maintained annually) where users enter a value of “1” at the intersection of each Cost Center and its correspon

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, Mikki  

Can we use an XFBR in a parameter like this and then use the parameter name in a DM step? 

Can someone provide any  documentation and use case for different Source Type in dimension properties section?    

This is a problem I run into off and on that's always been annoying but easy enough to work around... until now. When working in a QuickView, for example, I click on the Up Arrow (for Parents) and I get all parents, not just the parent in the hierarchy I'm actually working with. In the most literal interpretation, I can see why this happens. In principle, I think I ought to be able to control this behavior either by the Parent filter or through the addition of a field that lets me choose my current hierarchy. But, in a QuickView, I'm working with one member at a time so it's not the end of the world to just remove the irrelevant parents and maybe do a little manual editing of the member filter if it gets too messy and I really want to keep the QV for future use. The problem comes when using the Grid View set to Display Parent Child Relationships with a member filter to display the descendants within a key hierarchy. I get every parent child relationship for every hierarchy. There's no

Hi all,so I'm running a Finance Business Rule through BRApi's ExecuteCustomCalculateBusinessRule method, passing a POV through its nameValuePairs parameter.Since I need to run it from a WorkSpace for a bunch of different DataUnitPK, I'd like to run them in parallel. Unfortunately it doesn't work. It seems to me that:The first launch runs with a POV passed in parameters (let's call it POV-A)The second launch sets its own POV (let's call it POV-B)if the first launch is still running - and that's natural for parallel execution - every reference to api object seems broken, since it refers now to POV-BDoes someone was able to parallelize the above mentioned method ?Thanks in advance for Your help RegardsFabioG

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,Morgane

Here's the scenario I'm trying to figure out: My main dashboard has 3 columns which contain 3 different dashboards.  The left and right dashboards are just for navigation and have a set width. I want the middle dashboard to be center aligned with the available space left over after the left and right dashboards are populated. Basically I'm trying to design the dashboard so that it's readable from a laptop screen but on a normal monitor I want the main section of the dashboard (the middle) to fill in all of the empty space and center align horizontally. I hope that makes sense? Thanks, Brandon

Hi, I'm aware that from the Validate workflow step, the full list of invalid intersections can be exported as in the picture below (right click > Export): The Validation messages are not included in the export. Is there a way to export the full list of validation messages together with the invalid intersections?     Thank you

Have you seen a KB / post that met the requirements for daily data?Please share your experience / practical advice to help us meet daily data requirements.- for Planning- flat files: Daily Data per Month- flat files: Daily Import- Reporting by Day by Month Thank you folks for sharing your expertise.

I am working on security groups; can we hide these sections to selected users? I can't find the right application/security role for this. Thank you.  

What do you use as guidelines to flip the "inuse" flag on accounts or entities? Do you wait until the entity balances are brought to zero in your source or some other trigger? What considerations do you make around any immaterial translation values? Interested to hear what your company is doing - thanks so much!  -Nicole

Is it possible to build a dynamic cube from multiple cubes?  For instance, could I build a dynamic cube that had income statement level data from our month end close cube and summarized headcount data from People Planning?  To my mind this is where the power of Dynamic Cubes would really shine.

Hi Community,Did anyone have successfully used VBA to connect via Excel macro?I had tried all of the connection code from the link below without success;Visual Basic for Applications (VBA) ProceduresRegards,Seang

Hi everyone,I was wondering where there is an alternative way to create and manage users within an application without using the 'Cloud Administration Tools' dashboard. Any help is much appreciated!

Hi All, qq--is there a way to disable SSO login for one account. we have one user created in OneStream as a contractor, and now we want to enable that user to login to OneStream application without SSO.Our OS app is configured with SSO sign, so we get a code whenever we login, but i wanted to overcome this to the Contractor id, is there any way that we can disable the SSO login.  Any Suggestions pls. Thanks in Advance. ThanksSatish P

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//Suresh

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!

T#2027:V#Periodic, I'm pulling the correct YTD P&L numbers for 2027.T#2027:V#MTD, I'm only getting the December number.How can I get the MTD number corrected on the total Year? It should match Periodic? Thanks.