Application Build

Hello, When working in Workflows > Budget scenario, I would like to add a new column in People Planning that would depict new annual salary after discretionary merit increase. Any idea's?

In dashboard grid layout . What does the value in column width represents? 1. * 2. Difference between auto and * ? 3. How is the scale of the width measurement ? what is the total width of the screen? 4. What does 2* means ?  

Hi Everyone. I am running an SQL query, but I am now encountering an issue with currency conversions. The only thing my table contains is the column with the currency name, but it is not very helpful because the FX rates table only contains the ID. I would like to know where I can find the FX rate IDs and names in the query, or if there is an intermediary table to accomplish this. The tables I am currently using are: XFW_PLP_Register and XFW_PLP_Plan.

Hello Experts, Is there a way to update 500+ member names in OneStream using XML file. Manually changing each member is time consuming there seems to be no functionality available with XML load?Thank You,Manoj   

I have stats account, user is input the numbers for September Time period at base level in Actual scenario for Periodic combination and the -ve number are showing in October TImeperiod. that -ve number is YTD of September. as user is requesting to clear that October Actuals -ve data. Is there way that we can delete and also, I am surprised how this -ve number flow into the Oct Time Period. The flow is EndBal_Input. users are entering the number from quickview. Any suggestions to solve this issue?

Can we adjust the Workflow POV settings in the OneStream Excel Add-in? It would be great if the "OnePlace" tab could also be displayed. Many of our users are more familiar with the Excel add-in, so implementing this change in the next build would be beneficial. This way, they wouldn't need to access the application to modify these settings during the close process.

Is there a way to disable the "Force Consolidate" option from the forms? 

I'm sure this question has been asked before in the forum, but I just couldn't find it in the community. We have this requirement where in the same Actual scenario, Corporate (a group of users) can only access the Actual data after  the actual data is finalized by different entities. Any point of time leading to Day X, the entity has the control to pull the switch on releasing the data access to Corporate. On Day X, all the data is made accessible to Corporate. I thought about slice security, but it doesn't seem to accommodate this requirement due to the static nature of the DU filter; neither does Conditional Input, which doesn't control the general data access. Can someone please shed some light here on this design whether it's possible to lock down a group of users by time period? 

is there any documentation available explaining the details of File Explorer? What each of these folders are, when these will be used, these are consuming large hardware space, how to purge files in these folders, what are the pros and cons of purging. I feel there is a lack of documentation in this area.  

While not on the list of Reserved Words, I was wondering if Member should be avoided in Dimensions and Dimension Names? Could using it cause any unwanted downstream effects?

Is there a way to restrict Access to Business Rules for all Users including Administrators through Security Groups? I don't want to encrypt the Business rule.

Good Day,In order to implement Org-by-period Consolidation, you need to set the Consolidation View to Periodic so that the correct Share for e.g. the income statement can be calculated for only the period for which an entity was consolidated to a parent.The guidance is clear that "When Consolidation View is set to Periodic and no data is loaded to the IC Accounts fora specific month, custom Elimination rules are required". I assume this is because of built in zero suppression settings on the Elimination data buffer.However, here is what is strange to me and I'm not sure if I'm missing something.When setting the Consolidation View to Periodic and note that No Data Zero View is set to YTD as data is loaded YTD, for any entity, there is a problem with eliminations as follows:When loading 100 000 in January, the full 100 000 is eliminated. If you load 100 000 again YTD in February, nothing gets eliminated. If you load e.g. 100 000.01 YTD in February, then the full amount gets eliminated ag

Since many federal organizations utilize Active Directory at the Enterprise level, is there a way to tie Active Directory management to OS? For example, if a user's AD account gets disabled, so does their OS account? When a user's AD account is created in the particular OU, their OS account is created to the correlating group? Thanks. 

What is the simplest way to remove zero data from the application? This could be both calculated and user loaded data. Hoping this will improve performance. 

Hey Community,  So I am wondering if anyone has any smart idea how to split into multiple BiBlend tables when loading a file into workflow with workflow name Blend. My current DataSource is using Delimited files. And I have a column in table that I map towards a attribute dimension which contains of 5 different values. I would like to split the tables based on these values instead of loading file in 5 different workflow steps.  In earlier projects working with data mgmt export sequence data sources I have accomplished similar result by using connector setting "SourceFieldName" to do this. But this option is not available for Delimited File. So if anyone have any code snippet examples on how to hook any businessrule up with the data source or similar that would be extremely helpful!   

Hi Team, Is there a way to set the No Input period property for Scenario dimension using XFBR/Parameter dynamically through DM Jobs. for ex: a new scenario test2, needs to be copied with test1 scenario data across all years (Closed periods + Open periods).The requirement is to have "No Input Period" property as 0 during coping the data and later during consolidation thorough DM step set it to Current actual close period value (i.e for may close it should be 5).   Thank you in Advance.  

Hi All,   I have trying to get the Combobox type of drop down in the custom created data table . SQL Table Editor Searchable Drop-Down List (onestream.com) The above link the documentation to achieve that requirement however it does not work even tough i follow the instruction given in the document. Below are the screenshot of my datatable and parameters.    Kindly help me to achieve this requirement .   Thank You     

Hi Team, Is there a way to lock and unlock the scenarios through Dashboards?Followed to the above question, can we load FX rates through Dashboards? Best RegardsLucky

Hi, We have a service account setup in our EntraID IdP that is used to call the API. Now that we've enabled OIS, we're having difficulty setting up a PAT for the service account since typically nobody logs into the service account and accesses OneStream, so the account is unable to provision a PAT for themselves. Would anybody have any suggestions as to how to proceed? Thanks!

See the TWO screenshots below, the first is bad and the second is good. In dashboard design mode on some dashboards, what is causing the left panel to be blue? This is the vertical panel that shows all the artifacts in the dashboard.  This is preventing us from seeing which artifact is being selected in the right panel.  In this screenshot the "PDO To Update" label is selected in the right panel but the artifact is not highlighted in the left panel. This makes troubleshooting much more difficult. This is bad In this screenshot, the "Create New PDO" label is selected in the right panel and we can see the artifact hightlighted in the left panel because the left panel is not blue. This is good    

This is a weird question but how can I confirm what version I'm on within a OS application? I used to use the version on the top bar of the log in window in both excel or the OS windows app but I learned today that there's the possibility that our environment version is different than what shows there if the versions are not kept in sync by our IT team.  Any direction would be helpful!  Thanks! -Nicole

Regarding check box selectors (selecting multiple options) in some of the dashboards that I have created, when selecting an entity, the user has to scroll down until they find the entities they are looking for. So, I would like to know if there is a way in which I could add a search bar or similar that could facilitate the search of the entity, account or dimensions desired. I know it is a long shot but it would be extremely useful. 

Hello! We continue to run into below error when changing our Global POV (application properties) over to our new fiscal year 2025. When our global POV is set to 2025P1 we receive the below error. When our global POV stays on our last month's 2024P12 we do not get the below error. We feel like we've checked what we can in regards to the transformation rules, workflow profile settings, cube settings etc., and can not seem to correct this issue. Any suggestions are highly welcome. Thanks!  

Hello,  For one of our customers, we want to make the flow selectable in the ICP matching parameters (Closing and Merge). This functionality works properly in the data adapter, which is linked to the pdf report (via a member list Flow Dim parameter). Method Query used : {|WFProfile|}{|WFScenario|}{|WFTime|}{|!SelectPlugAccount_ICMR!|}{C#EUR}{V#|!View_ICMR!|}{|!SuppressMatches_ICMR!|}{|!MatchingTolerance_ICMR!|}{E#|!SelectEntity_ICMR!|.Base}{E#|!SelectPartner_ICMR!|.Base}{F#|!SelectFlow_ICMR!|}{} However, this option doesn't seem to be available in the native ICP Matching data feed in an Interco workflow step. The filter in ICP matching parameters does not accept the parameter F#|!SelectFlow_ICMR!|  OSXF version: 8.0.0 Could you share your insights with us if there's ever a possibility of having this flow filter selection also by Interco workflow step? Thanks in advance for your help !

In our recent discussion with OneStream team during a demo session, we observed that the version you guys using are different than the version we have meaning the UI, we still use the older version with blue colored interface, but you are using with new OneStream changed version in black color interface, when do we as a user's going to get it.