OneStream Platform Forums

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

I am storing a csv file in everyone path in filestore> Data Managemanet>Export> User folder. I want an BR that reads the file and compress (Create new .zip/ Override the .csv to .zip) and store in the same path. I am facing issues in same.

Could you please provide a sample script with example  to Generate the base mambers of UD2 dimension into a Variable. I'm trying to follow the below syntax, but it's not working for UD Dimensions Dim baseMembers As List(Of Member) = api.Members.GetBaseMembers(entityDimPk, entityId, Nothing) Appreciate your assistance.

Hello OS experts, I have BR that load P&L bucket and one BR that loads my BS bucket. I have DM sequence which load P&L,BS and then does consolidation etc. I want to know if I am able to write new BR or something I can do in DM to load P&L and BS data parallel to save time. Let me know your thoughts and example code if you are doing it at your job. ThanksSaurin *Migrated from onestream champions

I would like to reference in a BRAPI rule text stored in the workflow profile's Substitution Text Settings.  Can someone provide an example how to do this please. 

Hello,I'am newly at OneStream and now I have a requirement from a client:- They want to import, automatically, files that will be data source of a Workflow Profile = import;1. Those files are on FTP (FTP connection), that means that I need to add on the current application server, a connector type = gateway, right?  Also, what I need to define on the connection string?2. Then I need to create a BR for the connector;3. Since the files are "delimited files", so on the Data Sources menu, I need to create a new Data source - delimited file and map the columns to the correspondent dimensions that exists in OneStream right? Also, on the connector setting option, I need to assign the delimited file to the BR connector that I created previously, right?   4. On the Workflow Profile, I will assign it to the new delimited file. Are these the correct steps?Thank you all.Ricardo  

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

Hello,Currently a brand new customer and I was wondering if there's a way to automate currency loads from a SQL table to load into OneStream? We were told there was a way, but our consultants are telling us its not possible?Can it be done through a Workflow using Data Manager? Thanks,Will

Hi all, Happy New Year! Is there a way of extracting an active entity list from OneStream including Entity Name, Description, and Currency fields by using a data management job? Any ideas will be appreciated. Thank you!  

When trying to update another user's workflow view within OS, I'm seeing the following error. Replacing the current file with an updated xml works but I would like to avoid that if possible. Any ideas?    

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

I have a business rule that requires referencing aggregated divisional (entity) data several times over the course of the rule.  Base level entities run their rules and at a point in the rule, the entity needs the aggregated divisional result and so a consolidation to division. Can the data management jobs for consolidation have the consolidation filter set to C#Aggregated and the rule get the correct aggregated divisional numbers from the consolidation?  Or, is C#Aggregated only for data reporting?  Does the rule POV need to use C#aggregated when referencing divisional entity data or can this left out of the rule?  I have run some tests and the answer seems to be yes, DM jobs with C#aggretated produce data that can be referenced in rules and no, the rule does not need C#aggregated in its divisional entity POV.  Can anyone comment on this more?  Thanks.

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 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

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  

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

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

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!

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.    

All rules in business rules page must be written in Visual Basic.. Question Credit: Andrea Tout 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 have a CV Form where the input is a "Date" Cell Type.  I need to use the date to translate to a OS Time Period.  I am struggling with using the Date value in a Business Rule.  It only returns an Integer and I can't seem to convert the integer to a Date in the BR so I can grab the Year (Dim strYear As String = Date.ToString("yyyy")).  Any help with this? thanks, Greg