Application Build

Does anyone know if we can assign an Input Mask to Text Box components? Using version 8.5.4, I have a few dashboards that make use of Text boxes for data collection and I don't see a way to assign an input mask to the text box. An input mask is a string expression that constrains input to support valid input values. If the text box is expecting a dollar amount, the input mask would format the entry as number format #,###.00.  For capturing a telephone number (North America format), the mask would be (000)000-0000. If this doesn't exist, can the dev team add this to future releases? Thanks, Cosimo

Hi,I'm trying to create dynamic members within a dimension using api.ReadDynamicDimensionInfo.I created a custom table within application database. When the service runs, it creates members under the root member even when I pass the "Parent" member's name. Also, the aggregation weight is being set to 0 even when I've passed numerical values.Table:Dimension Library: I want the members to be created under "All_Customers"Code:It works when I use - CreateAndAddrelationships but not with the api mentioned above. Am I doing something incorrect?

Hi,I was trying to go back to one of the two Genesis pages (we have two instances in our app) using a button but seems like the following navigation action is not working.XFPage=Dashboard:[container_bag_(App)_(Main)_EU]I've tried using parameters in embedded dashboards to refresh the content and there is no way to go back to the home page.It appears that Genesis assigns the same names for all objects so it's a problem when trying to refer a home page dashboard only related to a specific instance. This is the reason why i renamed the home page Genesis dashboard with a suffix.For now i just opening the dashbaord i want in a new page using OpenInNewXFPage=True, but i prefer to make the back button working.   

We have added a power user who has the ability to manage some dimensions, however they cannot access the hierarchy validation tool and receive the error Security Access Error.  User XXXX is not authorized to access object 'OneStream Database Server'. I tried changing the access in the workspace but this did not resolve the error. What areas need to be changed to allow access?      

Is there an ability to calculate HC expenses that account for when in the month an employee starts and prorate accordingly? As an example, if the employee starts on the 15th then their monthly salary would be Salary / 12 * (15/30). The syntax available in the blocks don't clearly identify if this can be done. 

Hi, I would like to know if any major changes need to be carried over from 9.1 to 9.2 version upgrade. As we had some changes performed when we moved from 8.5.1 version to 9.1.0: Winscp to SSH.net Marketplace solutions to be upgraded to latest versions also Navigation center replaced applications reports, security audit reports. so, we had to remove the existing AR, SAR solutions. We had .vb in the extension wherever the xfbr has been referenced that extensions were no longer supported in 9 version. Thanks in Advance!

  Hi All, We have run out of text properties and are figuring out how to extend this and what the options are?Does anyone have some suggestions or ideas?Thanks in advance!

Hello all, It's unclear to me if upgrading the platform to v9.0.4 will impact the continued use of OFC PV 8.4 SV112. Does anyone have any insight if OFC needs to be upgraded to PV9.0.0 SV201 if the platform if upgraded to v.9.0.4?Thank you! 

Hi there,I am trying to extract a component using XFProj.  I worked with that in the past.... it seems there is a bug on 7.4.2 as the below code works in v5 but not in v7.4. <xfProject topFolderPath="XFProjMenu" defaultZipFileName="Menu.Zip"> <projectItems> <projectItem projectItemType="DashboardComponent" folderPath="" name="cpTest" includeDescendants="true"/> </projectItems> </xfProject>   The documentation does not mention anything about the workspaces.Can you guys test on your side on provide a feedback?Thanks  

Hello,I have been getting the following error trying to load a form template in OneStreamI've checked the intersection and it matches the white input cells I am trying to load to. Is there any other reasons this error would appear?Thanks

Hi OneStream Community,I had a question regarding extracting dimension metadata and properties from OneStream.Currently, when we go to the Dimension Library, apply member filters in the grid view, and then right-click and export to CSV, we can download file containing the metadata along with its properties.I’m trying to find out if there is a way to automate this instead of doing it manually.Ideally, I would like to extract the same information (based on member filters or a specific hierarchy) through something like a Dashboard, Data Management step, or Business Rule, so the export can be automated.Has anyone implemented something similar or know of an approach to achieve this?

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

In our first workflow step, we set the value of a literal parm using dashboard extender and then in next step use that parm in a DM job to export data based on that parm value. On windows client, our DM job works fine but when we try it on web, it does not find the value of the parm and errors out.  Can someone please share any experience with this kind of setup and how to make it work on web?

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

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 everyone, I’m hoping to check if anyone has experienced something similar. We have a dashboard that directs users to folders in File Explorer. The navigation itself works as expected and correctly opens the folder location. However, users are experiencing inconsistent behavior when trying to open files from there — sometimes the files open normally, and other times nothing happens (no error message). If users navigate directly through File Explorer and open the same file, it works without any issues. This is happening in the OneStream Windows desktop application (not browser), and permissions don’t appear to be the issue since access works normally outside the dashboard. Has anyone encountered similar behavior when launching files from a dashboard? If so, was this a known issue or did you find an effective workaround? Appreciate any insights — thank you!

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