Application Build

How do others manage User Names in their applications? We were advised to use FirstName LastName as the user name, the Description field is not used (screen shot below). We have single sign on enabled which uses AzureSSO and the employees 5 digit number assigned by IT.   We have several name changes that we have held off on making in our application.  Our application includes a custom compensation model that also leverages the User Name and a separate security model within that module.  We can replicate the name change in the comp model and test;  however we are concerned about other implications that we have not considered. Our implementation partner highly cautioned us from renaming metadata.    I fully appreciate the complexities with Entity or Account metadata name changes;  however in this User Name metadata, the implications seem small (historical logs will have the old name pre change and new name post change, possibly an impact to their f

  If you’re using a dimension for only dynamic calculation members, it needs to be enabled on the cube where you want to use that dimension. Question Credit: Chul Smith 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

Hi,  I'm trying to look up values from a VLookUp table (previously made in the Transformation Rules) within a Complex Rule in my Data Source, MMomentoff how could I this? Thank you very much in advanced.   Best, Nieves

I am trying to create a form template using all base and Origin as form.When I am running the form through WF,i get a light green shade in the fields where I need to key in data.Any suggestion as to why I am unable to see the white cells?

Hey All. I have a cube view for a client that contains a decently sized row count. I don't really understand why Data Explorer will only format the cube view to have 4 rows per page. Does the red paging mean anything?

Hi All, We are trying to load more than 100 rows through a table view using the method NumberOfEmptyRowsToAdd in the Business Rule: tv is our table view object.  However, when we add a value bigger than 100 in the code, no rows are available to load data in the Spreadsheet. We think is an internal limitation from Onestream to optimize performance. Is there any way to increase this limit? Maybe is only possible with some additional admin privileges in OS?    

Hi All,  In OneStream there are many audit tables containing specific sections that can be audited. I'm looking for a detailed overall data audit showing which user changed which number at what time. Preferably combining loads with (Excel) input. Does anybody know which tables to join to get the good old HFM data audit table?   Thanks in advance,  Marc

Assuming data exists at every base account shown, the data will be accurate at the 69000 – Net Income level using the following account structure in a monolithic cube. Question Credit: Chul Smith 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

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!

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

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 ? 

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?

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

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.

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?

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!

Hi, my Entity dimension has a main hierarchy with TopMemberA being the top member, and an alternative hierarchy with TopMemberB as top member. It looks like this:   TopMemberA - ParentA1 -- Entity1 -- Entity2 - ParentA2 -- Entity3 -- Entity4 TopMemberB - ParentB1 -- Entity1 -- Entity3 - ParentB2 -- Entity2 -- Entity4   The issue I have is that whenever I consolidate TopMemberA the status of TopMemberB changes to CN, and vice versa consolidation TopMemberB changes the status of TopMemberA changes to CN. I don't see why consolidating one branch of the hierarchy should change the status of an alternative hierarchy. Did anybody else notice this? How have you solved it?   Thank you  

Hi, Is there a way to modify the OneStream banner at the very top of both the login screen and the application window where the OneStream Logo could be replaced with a customer logo or anything else?  I know we can add text to the banner via the Application Config file, but I was wondering if there was a way to eliminate our logo in place of something else.  One of our military customers is asking this question.   Thanks, Ed Wright

Hello fellow OneStreamers, I have a burning question that I need to get insight for in regard to environment care. We have a cloud instance of OneStream and have multiple apps on our prod environment. We would like to have a good overview of the app sizes, perhaps in a nice dashboard, so that we can preempt our need to order more storage space and prepare our release schedule. Is anyone using or has developed anything like that? Currently we have to send a ticket to the help desk to know the app sizes and would prefer to have in in our-hands more on demand to plan. Thanks!

Hello! As a EssBase previous user, do you know if it's possible to navigate without data or at least positionning row and colums dimansions without a refresh and once all is done proceed to the refresh. Because  sometimes when it makes 4 minutes to refresh a cubeview and I have to move at least 5 axis to column or row, it takes 5 x 4 minutes Thank you in advance. 

When creating a loadable xml format for bulk user creation using internal authentication, we face issue while signing in using the created users (the password encryption and decryption might have caused it)Is there any way out to solve this?For eg. : We created a user TestOS with password as Welcome1 using xml, but when this user tries to log in using the same credential, the user faces sign-in issues.