Application Build

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.

Hi the community! Do you know the way to proceed to retriev in a cubeview a specific UD where the text of it is set on a specific value? For example I want at the finest level all my UD1 which contain as a Text4 "Long_Lines" I write this as a formula : U1#Shipping_Trade.Children.Where(Text4=Long_Lines) But nothing appears as a result. Did I missed something? Thank you.

Is there a good resource that people use to explain what is contained in each version of OneStream. I read the release notes but I am looking for perhaps a good blog to help explain these features in detail. I typically meet with our Finance users before we upgrade to let them know any features that may be useful to them.

Hi, Do we get to see the member updates made in Dimension Library in the Task Activity? I don't see a Task Type related to this in the Task Activity. It gets recorded when I use an XML file to update the dimensions, but not the manual changes made there. Is there any setting that needs to be made to get this information in Task Activity or should I be checking somewhere else? Please let me know. Thanks in advance, AK  

Hi All, We are looking for a way to put a currency override on movement flow member (ex. dividends, redemptions, etc...). The current override logic which was provided was OneStream is leveraging the flow dimension to conduct the currency overrides so I am having trouble in determine the best way to work around this. If anyone has come across this before please let me know. I'm looking forward to hearing from you. Cheers!

Hello!  Looking for some feedback on how your company records and reports on both IFRS and GAAP standards. Do you use a UD as a sort of data type to record adjustments where they differ between IFRS and GAAP? Or do you use different accounts with an alternate hierarchy? Or something different?  Interesting in hearing from anyone with any suggestions - thanks!