OneStream Platform Forums

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, we are 'suddenly' seeing an increase in the time for a matrix data source import to complete the validate intersections step.  It has gone from 5 minutes to over 2.5 hours to complete one step during the import step of the workflow.  The subsequent cube load takes another 2+ hours of time once the validation step completes (for a total execution time now over 5 hours).We have backed out all changes since the previous execution that completed in 5 minutes with no change to the time.  We currently are not suppressing zeros on the data source, however even with that enabled in our QA instance, the time to complete the validate intersections step is still much longer than 5 minutes (40+ minutes).Any suggestions on what else we can check?  We are currently on platform version 7.0.1. 

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

Is it possible to create a popup msg in a DM business rule like the msg below (created when 'Complete' is clicked).  The Load button calls a DB business Rule and I need to first check if WF channel is locked or not.  If locked I'd like to notify the user that the channel is locked and the BR is running    

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!

Hi All,I have been trying to understand the process to setup On-Prem Oracle DB connection in OneStream Cloud to export data from cube. Is there a document that you guys can point to? The doc I found didn't help much as it seems it is for On-Prem OneStream version. Thanks in advance,Mikki

The default length of visible line items for comboboxes seems to be eight. Is it possible to change this to larger numbers? Often there is more space on the screen and this would help avoid unnecessary scrolling. Thanks! (example from GolfStream App)    

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  

This was posted originally in 2019 and added to Office Hours in 2021. Please See below for follow-up question: Question:  Is it possible to have a historical override for a single account, but for multiple currencies?  If I have an equity account which I would like to have a USD override amount, a GBP override amount, etc.  On the Override account settings, I can only choose 1 currency.  How can I resolve this? Answer Yes, this is possible but on your closing balance Flow member, you will have to use a rule instead of the “Source Member for Alternate Input Currency” property, since as stated in the question, you can only choose one member here. The flow would look something like this: Opening Activity FX Closing This member would have a rule that uses this logic: If base entity and foreign currency then   If currency is EUR, then = Override_EUR   If currency is GBP, then = Override_GBP, etc… End If Overrides (one for each potential currency you

Hi All,I am wondering if anyone has an opinion on using slice security for specific UD3 level security vs. using a Finance Business Rule to control access to certain UD3 members.  Basically, I am looking to say if a user is in a certain security group, they should not be able to write data to certain UD3 members.  I believe it can easily be written using slice security (Cube Data Access Security) or with a conditional input FBR (if user in g.  I see an advantage to not having to update every entity with turning the Data Access Security to True and potentially adding categories vs with a BR, just writing a rule that doesn't touch metadata.  I tend to typically try to avoid 'touching' existing metadata if I don't have to especially when adding in a Planning Cube next to a pre-existing and well established Consolidation Cube.  Does anyone know if there is any real pro/con to either approach other than less updating of metadata which I mention above?  Would pe

Hey everyone -  How do I clear data from these workflow manual imports automatically?Right now, I've been going through each month one by one. Wondering if there is a BR that can run them all together and clear up data from those specific imports and time dimension. Here are the steps I want to follow: Navigate to import that needs to be cleared > Clear > Re-Transform > Validate > Load Cube    

Please let me know what you have done to pass a dashboard parameter to a data unit filter e.g. Entity on a Data Management step.   For example, if we have a dashboard parameter |!Selected_Entity!| which stores the entity member selected on the dashboard, using it on the Entity Filter in Data Management (E#|!Selected_Entity!| only works if the dashboard parameter type is a Literal Value with a Default Value set. The default value can then be changed with a business rule with the SetLiteralParameterValue function (this is also the setup in GolfStream).   The problem with a literal value parameter type is: where user A selects the entity on the dashboard, but before user A kicks off the DM step from the dashboard via e.g. a button, if user B changes his/her entity selection, the default is changed for everyone, so user A will kick off the step for user B's entity.   Trying an XFBR rule to set the default value of a Literal Value Type - it seems

Is it possible to add an assembly reference to OneStream that will allow the BRApi to reference the Microsoft Outlook Object Library....or any other library that is not currently included in the OneStream.I would like to provide a dashboard button that allows the user to open up a new Outlook email message.  Done similarly in other VB.NET projects like this<add assembly="Microsoft.Office.Interop.Outlook, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"/>  Imports outlook = Microsoft.Office.Interop.OutlookDim OutlookMessage As outlook.MailItemDim AppOutlook As New outlook.ApplicationTryOutlookMessage = AppOutlook.CreateItem(outlook.OlItemType.olMailItem)Dim Recipents As outlook.Recipients = OutlookMessage.RecipientsRecipents.Add("myemail@hotmail.com")OutlookMessage.Subject = "Sending through Outlook"OutlookMessage.Body = "Testing outlook Mail"OutlookMessage.BodyFormat = outlook.OlBodyFormat.olFormatHTMLOutlookMessage.Send()Catch ex As ExceptionMes

I would like to know from fellow OneStreamers how you’ve done your monthly and quartely forecasting process. I’m not necessarily looking for a solution. Just ideas on how this can be done.i need to seed the forecast from actual and budget and then be able to visualize them through the workflow and be able to adjust budget data through load of file. how can i link the BR of copy with the workflow and to adjust the data , is it possible to override the data copied by loading a file ? i thought about adding a workspace for the BR of copy than import on the workflow name but i am wondering if there is better solution (best practice) for the forecast process.

Hi all, When I come into the marketplace to start evaulating when I should do my next software update, I see that there is a dropdown in the platform area that shows 7.1.3, 7.2.1/2/3, 7.3.0/1. I'm updating from 7.0.1 and would like to access 7.1.1/2 even though they are minor hotfixes, they should still be available for completeness? Maybe they're available somewhere else? Thanks for any insight

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

Hi All,We'd like to have a Form Template available only until 2022M9. To do so, we've entered the following parameters in the member Frequency filter of the Form Template:Is it possible to have a more dynamic way to apply frequency to all previous periods, other than hard listing it?  Thanks in advance! 

I need some help building out the following two calculations on stored member formulas. They would need to run at every UD. 1) = MIN((A#Account1 - 4.5%), (A#Account2 - 6%), (A#Account3 - 8%)) 2) = MAX((A#Account1 - Account2 - Account3 - Account4),0) Thanks so much!

Hi, I'm trying to pull in the descendants and the parent member of an account into a data buffer. e.g. something of the form FilterMembers(A#All, A#Gross_Sales.DescendantsInclusive). When I log the data buffer and examine my results, however, I'm only seeing the base member data and none of the parents. Could anyone provide me any suggestions on how to pull all of this data into a single data buffer? And can anyone tell me why my data buffer doesn't produce the results I'm expecting? Thanks!

Is it possible to use MTD & YTD in View filter for a Data Management job.It does not work if I use -  V#MTD, Y#YTD, but this format seems to work for other filters like for time if I sue T#2021,T#2022 there are no issues. But only for View filter using multiple filter seems not to work.Do anyone know of any workaround to resolve this?  thanks Kumar 

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. 

It appears to be possible to set the SiblingID in RelationshipPositionOptions, so it exists as a property.   How do I "read" it to see what it is for a member? Thank you in advance for any assistance.    

Hi all, i'd like to ask how can i get in the metadata builder view an initial complete version of the dimensions each time before adding new items?When i have to update the application dimensions,  i would always have the previous situation in metadata builder template as a starting point.Any suggestions will be appreciatedthanks you