Discuss the features and functionality of OneStream.
Recently active
Hi, We are storing project plan data in a custom table in OneStream and loaded the data into a cube. We are having a requirement that a single project may last 2 to 3 years and if the user wants to see the project plan of a particular project from the start date till the current year, how to get it in a cubeview. Thanks & Regards, Madesh K
Is there a best practice to get the report headers to be a consistent size regardless of the Rows and Columns in the report? We have the Standard Reports under Application Properties setup to drive consistency, however it appears the columns/rows formatting of a particular report is driving the size of the report header. In the example image, we have identical report headers with different column sets. The top report has more columns which is resulting in a smaller report header. It seems that should not be impacted by anything within the actual body of the report. Second report formatting question: Is this functionality available? The answer says it was expected back in 2020, but I can't seem to find where this feature would be. Question: Are there any updates on merge and cent... - OneStream Community (onestreamsoftware.com) Thank you, Aric Gresko OneStream Administrator | EverCommerce
Hi, Ever since some of your users shifted to windows 11, they cannot access OneStream web-based platform any more, because Internet Explorer is not compatible with Windows 11. So, they cannot downloaded the windows OS app any longer. Have you guys already experienced this? How did you overcome this obstable? Thanks a lot for your support. Best,Chris
Hello - I have a SQL data adapter that connects to an external database for data loads, dashboards, etc. Is it possible in the query to join these external tables to tables in the Application database? The server name in the error is the OneStream database server. Thanks,Bil
Hi,Can anyone explain why External connection is not working in SQL Table Editor ? The same connection is working for Data Adapter.Screenshot for Data Adapter and it’s working. Screenshot for SQL Table Editor and it’s not working. I tried giving the schema name as well but no luck. We are on version 6.4.ThanksSri
Hello Community, Do we have a way to check any missing member setting in an automated way? For example: Recently we had someone create a few entity members/rollups, which were missing "Auto Translation" setting. So I had to go in and scrub through region/district/branches to amend and change it to USD. Just curious, if we can "search" where a particular setting might be missing using a simple Business Rule. Maybe it throws a list of members where such setting is missing. Any idea will be appreciated. Thanks everyone
Hi Can anyone suggest , how can we automate loading of metadata into onestream from a flat file /table. What is the format of the file. I am aware of loading using xml from utilizing the metadata excel builder utility , but my client wants to automate metadata update in Onestream. I am not finding much documentation around that. How is this achieved ?
SOURCE: ONESTREAM CHAMPIONS Hi Everyone, Curious to hear others’ experience in the area of Security. At BDO, we currently have: 5k users configured, of which 4.5k are enabled. 3.6k are in our “basic” level security group, which we have automation to create and assign users to this group when they meet certain criteria. We have seen in our first year live about 50% of our enabled users utilizing our Production App at some point during the year. Primarily focus on Data Level Access (Cube Slice Security) to control access, which 1 of our 3 cubes has 137 slices configured in it, which is the most granular of our 3 cubes. For groups we are currently at 312, of which 150 have users directly assigned and the others are for nesting shared access across groups. For security, we do very little control by Entity or Workflows since most access to data is controlled in Cube Slices based on our U2 (Location) and U3 (Department), and outside of our automated loads, few users load data via workflows.
Has anyone experienced an extensible finance message stating "stream was too long" while using a quickview? I received the message after using UD4 as a column dimension and selecting more than 1 member. I set the maximum rows and columns to 50,000
Is there a way to allow different entity security for different processes in OneStream - particularly when implementing a Marketplace solution which is in a separate distinct cube, with separate distinct scenarios. For example, the user may have RW access in Finance cube to entities 1,2, and 3, and needs RW access in the Tax cube to entities 4, 5, and 6. How can I prevent them from having RW in both cubes to 1, 2, 3, 4, 5, and 6? I expect similar need may exist between actual and forecast scenarios in the Finance cube...
We are trying to format the point label text in a chart for the dashboard. We are able to format the value with the syntax "{V:0,0}". We also want it to have the font color black. We have tried several options, but whatever we punt in format or back of the syntax it will print that text. In Excel you can format numbers like [Red]#,##0 and it will display the value in Red. In the OS chart the result will be [Red] 10 for example. Does Anyone know the syntax to use to be able to control the font color of the labels in a chart?
Hi, I changed all font family and font size settings to Arial and 10 in OS under Application Properties/Standard Reports. It looks like all cells that were “written” by OneStream came through as Arial 10, but the cells that were not edited are still Calibri 11. I even tried to change my Excel settings to Arial 10 to see if that would work after exporting and had no luck. Any idea? Thanks, Hadi
Originally posted by Ashok AmreshWe are looking for a way to refresh excel workbook with the add-in in automated fashion. did anyone do it with okta sso authentication? basically looking for VBA version of below power-shell code. has anyone ever done it? Appreciate any help. $ssoToken = $xfApi.Authentication.ProcessSSOAuthenticationAndCreateToken("<server address>", "Username", "Password", [OneStream.Shared.Wcf.XFClientAuthenticationType]::ClearTextPW) $xfLogonInfo = $xfApi.Authentication.LogonAndOpenApplication("<server address>", "username", "$ssoToken", "appname", [OneStream.Shared.Wcf.XFClientAuthenticationType]::ClearTextPW)
Scenario property, Calculation Type: calculate > Execute Scenario Hybrid Source Data Copy > TRUE - does this really improves OS system performance? Can anyone give me an example of where using this really HELP. I can do the same job with Planning rules and Cube View reports.
Hello All, I have two elements, let' say for example "KPI before 2020" and "KPI after 2020". I would like to create a cube view that's shows>>> only "KPI before 2020" when my POV time is <=2019M12>>> only "KPI after 2020" when my POV time is >=2020M01 Currently my cube view result looks like: My desired outcome: Any ideas how to create such cube view? Best regardsJarek
Is there a way to display the report header for a cube view in the Excel Add-in? I have the Report Header section of the cube view designer filled out in the application, but when adding a cube view connection in Excel, it does not display.
I'm curious to know what others have seen during an external audit. We've been asked to provide change request or service request ticket evidence for any change made to our OneStream production app. This includes metadata, transformation rules, cube views, etc. We're being asked to provide ticket information in addition to screenshot evidence of what was done for any change of any object. Has anyone else seen the same?
Does anyone know if it is possible to combine multiple data extracts into one file in OneStream?We have several DM jobs that we want to extract information about what contributes up to parents. We have found no way to do this in one DM job as the filters needed for each just won’t work for multiple rollup points. So alternatively we thought if we could combine those files it would work. Or perhaps a business rule that could somehow loop through the hierarchy we need and ‘build’ the larger file to save to the file explorer?
I have a Stage Attribute of text type attached to my source records. As expected, this drops off when I push data from Stage to the Cube. When I run a query in the Excel Add-In and do a drill-down back to source at the base level intersections, I can see all dimensional values except the Stage Attribute #1. Is there any way to enable this? Thanks
When I look in GolfStream demo app, we retrieve a OS dashboard on a ppt doc using a dedicated chart component. Is it the only way we can use in order to call an OS DB from a XF doc?
Hi,How do I attach another CV (i.e base scenarios) under a flux analysis report? This is how my flux report looks: I understand their a row/column sharing feature, will that work? If yes, can someone please share how to set it up? Thanks!
Can we add these expansion to a parameter, and have the user select on their own? I was able to build a entity selection parameter, however when I run it, it pulls in everything (branches, regions, district) because I have used "Tree Descendent" expansion. But it would be preferred if I could add a expansion parameter (Children, Base, Tree Des, Member etc) and have it prompt the user to select. This is how my dialog prompt looks. Looking to add that parameter in their. Let me know if this can be done? any example will be appreciated. Thanks
My dept wants the ability to search data across region, district, and branches. I was wondering what would be the best way to build that functionality. Currently, I have build a Select Region Parameter, which has a BR rule running these cases (member filters). And it only shows region level data. This is how our report looks like. (Data is omitted) However, I'm looking add an option to select districts and branches, Maybe the QV can have a button to add additional rows, by clicking "+" and selecting those specific branches from a dialog box. Or maybe a dialog box, which prompts the user to build their own entity member filter. Hope that gives an idea of where I'm heading. Any suggestions or ideas will be appreciated. Thank you!
SOURCE: ONESTREAM CHAMPIONS Hi all! We just upgraded to 6.4 last week and have migrated our data management jobs running via power shell script onto Task Scheduler. A few questions: Do you set these jobs up with a certain person’s user name? Do you know what happens if that user is later disabled? (I’ve submitted a OS support ticket for that last question). If you don’t set them up under a specific person’s user name, how do you set them up? We have an “Administrator” user and “OSAutomation” user that I’m considering using to keep these auto jobs separate from my regular OS activity. Any insight would be appreciated as I’m trying to gauge how other users have set up Task Scheduler while also asking OS support for their best practices. Thanks!-Nicole
SOURCE: ONESTREAM CHAMPIONS Hi Team, Did anyone successfully able to set up the email configuration for RCM or Workflow profile completion or certification. Best Regards and Thanks Darpan Bhansali
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.