Application Build

Hi, AllWhat's the best way to ensure a specific tree within the account hierarchy has only one member within it.   Would like to have a "count greater than one" alert or a report we can run, as inadvertent accounts affect data integrity.TIA!

Hi everyone,  In the dashboard, I have setup my dashboard header, and linked it with the main dashboard but when I view this dashboard in different screen, the header loses it formatting. Anyone know how I can maintain the header format in different screens?

My requirement is to load 50 users in Onestream application, instead of manual updating , is it possible to load users in Onestream application ? and please let us know the steps. thank you

hi , i am trying to add the users in OneStream planning application, how to add the bulk users in OneStream, tried with extract xml file and copied that in Excel but formatting is not supporting.  Note: External authentication Provided is AzureSSO Thanks in Advance

When mapping an item from the "Validate" step in the workflow, it is possible to save the mapping to an "(unassigned)" item.Is it possible to restrict the storage of the mapping so that it cannot be mapped to "unassigned"? Thank you

We are wanting to know how other government agencies are doing for their prior year financial statements. What is your solution on how to handle retroactive system changes within OneStream? 

Can you please guide me the definition for the below points - 1) What is number of NODATA,Zero,Real,Derived cells ? And why are they all under NODATA Status ? 

Originally posted by Kostas Daikidis   I'm having trouble setting up OneStream Golfstream sample on a standalone (app server, web server and db, no SSO) Windows 7 Pro machine for learning purposes. I have all the prerequisites, however, the app server fails to start with the following message: Error starting application server 'localhost' Please contact the System Administrator to resolve the issue and restart the server.Application Server Configuration Folder: 'C:OneStreamShareConfig'.Framework Database Schema: 'OneStream_Framework'Selected Server Set: 'Standard' I've followed installation instructions to a tee and tried clean install twice already. I'd appreciate your help.  

Been searching for a while on the forums and knowledge base and documentation - maybe I'm not searching with the right text because I'm sure we can't be the only ones to deal with this. In a multi-tabbed dashboard, we have a button on each tab to 'Refresh CubeView' which is supposed to refresh the current cube view. The button is connected to a "Selection Changed User Interface Action" and the action selected is "Refresh" with a number of dashboards listed to be refreshed. Our problem is that when the Refresh Button is clicked on, after refreshing, the focus takes the user away from their current tab and re-selects the first tab in the dashboard. Does anyone know if there's a way to control this so that the focus remains on the current tab?

We have a lot of Cube Views and most of them have multiple validations some of which are quite complex.We also want to use Confirmation Rules to check that these Cube View validations have been cleared. The prospect of duplicating the Cube View validations in Confirmation Rules is not pleasant so we are looking for alternatives. We were thinking of adding a summary validation to every Cube View in the same place and then (somehow) saving that single value to an account with a split on UD6 for the Cube View. That would mean the Confirmation Rules are very simple to write. The question is can you save a value calculated on a Cube View to the Cube? The FormsEventHandler only references data that has been input (happy to be corrected on that). Suggestions on how to do this or a completely different approach are very welcome. Thanks

I am having an issue with cash flow report taking last month's (ie Dec 2022) value to aggregating it to the year to date (ie 2022), ignoring other months (... Oct, Nov, ). Does the account type get affected by the view dimension, whether periodic or YTD?  Or this might be affected by other settings in the dimension. The scenario settings for the Forecast for Input View for Adjustment are periodic, similar to No Data Zero View for Adjustments and Nonadjustments. 

FX Rate Types can be locked by Time. Question Credit: Eric Osmanski Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello,Would anyone have any issues upgrading your current version to 7.1? It’s my 1st time upgrading our current 6.4 to 7.1 as I just came on-board as ABA couple weeks ago.Appreciate if you can share your experiences.Thanks.*this post has been migrated from Champions

SOURCE: ONESTREAM CHAMPIONS Does anyone have any tips or best practices to make it clearly visible when an admin is in Production vs. Development? Obviously next to user name we can see Production or Development, but other than that one word, they look identical. I’m thinking of something like a big red “DEV” logo at the top ribbon next to OneStream XF or something similar to that.

1. Why is the "Total number of stored records" same across all months for one year ?  

Hi All,   I have created new Transformation Group and Profile ,If i try to link my group with Profile by using "Manage profile Members" icon i am not able to see the group name in the Available Groups list. Do we need to change any settings for that? Can anyone suggest?   Thanks, Dhanitha.

Hi, We will be setting up tables using Table Data Manager to store some filtered extract of application data. My question is how can on-prem folks access these tables? We were wondering whether we should just use on-prem database and use BR to extract the data to those on-prem tables. But this means we have to rely on IT to maintain those staging tables and access.  I prefer keeping the tables in Onestream app and give access to those tables. Thank you, Mikki

Is Application build for administrators course available in OS Navigator?  I have seen reference to the ABA course in  Administration Certification Exam Prep – December 2022 webinar, but can't locate the actual course link in Navigator. Thank you

Hi, I'm getting this error on different applications in my OS instance. Apologies if it is not relevant to this forum.

Happy Feb! how do I sync Prod with DEV ? We made a lot of changes to DEV over the past 5 months - but didn't upload all of our changes.  We are thinking of exporting a complete extract of metadata, Cubeviews, dashboards, datamanagement, DataSources to xml from DEV - then delete all metadata, Cubeviews, dashboards, datamanagement, DataSources before uploading our extract to PROD?  Both servers are in different physical locations and therefore have different firewalls. Is there an article regarding life-cycle management for OneStream ?  

We have a requirement for ALL users that log in, to acknowledge a set of system messages before gaining access to the application.  Other off the shelf applications have this capability built-in.  If it does not exist in OneStream, would the best approach be to create a dashboard and make that the home page for all users?

Hello,We need to create bulk users to perform stress test.We tried to use the suggested solution in the post Solved: Re: Issue with bulk native user creation using internal authentication. - OneStream Community (onestreamsoftware.com), by removing the line <encryptedPassword> in the XML file, in order to have the default password, without success.We would like to provide directly a different password to each user (even if he will have to change it afterwards).What are the best practices to perform it ?Thanks,Regards,Harry 

Hello All, We have a requirement to make some text display dynamically showing or not based on whether the entity member selected in a combo box is a base member or a parent. In my XFBR, I found this function that would give me this information but when I set it up, it returns me false, whereas in some cases, the entity selected had children (so is a parent). "Dim IsParent As Boolean = BRApi.Finance.Entity.HasChildren(si, EntitydimPk, SelectedEntityID, Nothing)" Could you let me know where my function's set up could be wrong or also if you would propose to use an other solution to achieve this requirement ? Thank you

When OS call an authentification API, OS use the IMPLICIT parameter. This parameter is deprecated since 2 years. When are you going to update these calls with the new standards?

Hi All, I was wondering if anyone had experience adding cultures to an applicaiton after go-live. Considering this is a system wide change its difficult to test without applying across all applications. I'm wondering if the statement in the attached screenshot "impact overall environment or application performance" would be applicable to adding new cultures.  Looking forward to hearing from you all. Cheers!