Discuss the features and functionality of OneStream.
Recently active
We created Extensibility BRs that leverage WIN SCP commands to send data from OneStream to an internal directory using an SFTP connection setup with OneStream. The data files are being received with a .filepart extension. We were able to get the .filepart feature disabled in our OneStream environment; however, the csv files are continuing to be received with the additional .filepart extension. Any suggestions on how to eliminate .filepart extension when files are sent / received?
With SQL Connector as Data Source, can we automate to Import, Validate and Load multi period and multiyear data (Ex: Jan 2023 till Jan 2026) in such a way the Import, Validate and Load occurs one period after the other sequentially?Query execution times are much lesser when pulling one period at a time Vs pulling ALL 36 periods together, so I want to explore this option.
Hi Team, We have a requirement to generate Level 1 member list (Department Member List) based on POV (Entity Dimension) selected so we have developed XFBR script to generate the Level 1 Member List. Now we have to generate Level 2 Member List (Product Dimension Member List) based on Level 1 (Department). I am not sure how to reference or Pass Level 1 information as a parameter to XFBR script? POV Entity=>Level 1 Member List: XFBR(POV Entity) =>Level 2 Member List: XFBR(Level 1). Not Sure how to refer or Pass Level 1 information as a parameter to XFBR script. Thanks, Sudhakar S
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 ?
Hi all, I'm looking for a possibility to dynamically create a Cell Format via an XFBR Rule. Unfortunately it doesn't seem to work, but also does not give an error message. Could someone please let me know, whether and how it is possible? The script is e.g. returning something like "|!MyFormatParameter!|" in the easiest case. Thanks in advance Markus
I am trying uploading a .csv file but i am getting transformation errors. In the source file the 3 rows are blank. How should I set the criteria value text anywhere within a line that triggers the lines to be bypass
Dear Community, For one of my project I need to get the values of a given cube view as a data table within my business rule. I can fairly use the FdxExecuteCubeView which will give me this kind of output : Cube Entity Local Scenario Time YTD Account None Top None None None None None None None None None 22.86874 21.68644 1.182297 5.451777 while my cube view is only showing accounts in rows and time in columns. One of the problem here is that I don't get the columns headers for the values ... So my question is : is there a way to get an data extract in a form of a data table directly from a cube view with the same rows & columns headers only ? Many thanks and happy holidays !
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?
Hello, Has anyone used the DataManagementEventHandler business rule before and identified the CalculationType of the DM (i.e. Force Calculate, Consolidate...)? And also the Data Unit and the POV of the DM? Colud anyone share an example? Thanks in advance,
I have a dashboard that has 2 components,. 1. A Combo Box that is populated with a sql query in a Bound List Parameter. 2. A Spreadsheet that is populated with a Table View. The table view is generated using a Spreadsheet Business Rule. How do I pass the selection from the combo box to the table view? Thank you for any suggestions.
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
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
If the workflow time is 2020M3 and you used the time function T#YearPrior1(|WFTime|)PeriodNext1(|WFTime|) it would return 2019M2. 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
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?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.