OneStream Platform Forums

Hi Team,We would like to understand how to  copy data from some specific tables fromappsuite(appsuite-prd.onestreamcloud.com) to appsuite_dev(appsuite-dev.onestreamcloud.com)for some specific tables.

Hi All, Is there a way to visually see in a Cube View that a cell has a document attached to it? The purpose is to attached supporting documents to some Cube Views. Thanks  

Hi All,I'm creating this report which uses a custom formula, that takes SUM/AVG of past six months, and calculates the Pct value. I tried using Rolling6MonthTotal and Rolling6MonthAvg  view dimension in Denominator/Numerator, but it doesn't work as it should. Any ideas on how I can make SUM/AVG the prior 6 month, and run this calculation (highlighted). Thank you for your help.Best, Mustafa A  

SOURCE: OneStream Champions I have a cubeview in onestream. If I launch one of them via the api it runs in 45 seconds. If I start two of them at the same time, they both finish in about 1:20 (a little over a minute, which is almost double the 45 seconds).     https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/fdaa8e3ec877c251814ffe035f4895e65ba2dbc7.png image.png2140×180 24.7 KB   What is the reason for the extra amount of time that is spent per report when two are running concurrently? IE. what internal resource is being protected against concurrency? From a technical standpoint, it seems very unexpected that two readers would block each other in this way. You can see in the screenshot that there is plenty of CPU available. I’m assuming this topic isn’t specific to our environment or to this cubeview. Nothing we are doing seems exceptional or unusual in any way.

Hi,  Regarding IC matching, is it possible to have a parameter with different Group entity levels in the dropdown? Regards,  Lovisa 

Hello & Happy Friday.How do I over-ride a cube view cell amount? For example: IF an account (for e.g. Fleet Revenue %) is less than a certain number (for e.g. 45%), then run a custom calculation in all those cell. Else, show the original number. The excel-sheet uses an IF statement as shown below. I'm thinking that I have to write a BR (with nested IF) to run this. Will be great if there is a existing BR or method somewhere else, that I can reference. Any ideas/suggestions will be appreciated. Thank you!   

I have created a DM sequence that calls multiple steps.  One of the DM steps prompts the user to select a seed Scenario which I then pass to my Finance BR as a parameter value.  The scenario options are presented to the user as a Member Dialogue Parameter object.  This works perfectly when I run it directly through Data Management.Next, I create a Dashboard for all of this using Data Entry 123 for display.  The user sees a button component that is configured as 'Execute Data Management Sequence' and I give it a Task Argument of {Phasing_BUD_Seq}{} which is my DM Seq.When I test this from my Workflow (uses DE123), it does not prompt the user to enter the Source Scenario from my Parameter, it just fires the DM Sequence.  It seems like my member dialogue parameter is somehow being supressed or skipped.Does anyone know what I am missing here? Thanks

On a couple occasions the users of the OneStream Add-in have unintentionally reported partial results from a onestream cube.  This has happened when data extends beyond the allowable page size ("Maximum Number of Rows").   It can sometimes come up by surprise.  For example, a user may pull in all the YTD activity from a cube and it will fit within the page size for much of the year but towards the end of the year some of the data will go missing.  If the Onestream data is retrieved on one of several sheets, and the data is used indirectly for calculations that are displayed elsewhere in the workbook, then the problem can be easy to miss.    In fact, this type of a problem can even be overlooked when you are staring right at the add-in itself, since the only indication of a problem is way down at the bottom of the results.  That is where you can see the "Page 1" annotation (see image below)     This brings me to my question.  Is there a

I'm having trouble figuring out how to organize the layout of my cubeview.    I'd like a tabular layout where dimension levels will occupy their own columns.  Below is an example where I am retrieving data from my cube by week.  But I want to display the parent month and quarter in their own columns, next to the weeks.       I am able to build the layout shown in the first image above.  This is accomplished using TreeDescendants for the year.   But I can't find a way to organize my quickview in a tabular layout (see the second image). Any help would be much appreciated!  Sorry for the basic question.  (I haven't yet found a good source of training material for Excel quickviews.)  

Hi All, Happy Friday, I am building a form and in my cube view I am giving option of selecting Entity, Based on entity I need to show two Dimensions  in the detail, we don't have any connection between these dimension. I can not update the Text field of entity because there are many to many relationship, One entity can have multiple project and ICP, so based on selected entity I need to show all related projects and ICPs so user can adjust the data. Selection - Entity Projects   -     ICP    $$$$

SOURCE: ONESTREAM CHAMPIONS Hi All,We are at the point in our implementation where we are thinking about managing security and our userbase. We are going to have ~600 users as we are very decentralized with our financial management, and we currently have our SSO setup with SAML. We use ServiceNow internally for all things workflow/helpdesk related and were going to be building the workflow for user creation/modification and their roles. Knowing that OneStream also uses ServiceNow for their integration I am wondering if there’s any thing out there to automate certain things from ServiceNow, or if we can script a .xml file out of ServiceNow to our staging database and have that loaded to OneStream to make the changes. If anyone has any ideas or experience I’d love to hear, as we are going to be having our OneStream system as an “in-scope” software from an audit perspective and want to have some tight controls around user management. Thanks,Jeff

Dear OneStream community,I'm trying to save the data on this gridview on a shared folder, does anyone know how i can do it ?  Once i will save it on a shared folder, i will put a business rule on the "initiate export" to tranform it and eport it in my computer this time.Please advice if you have any idea how i can do this,Thank you

New to OneStream but thought I would post an issue where we have an integration that runs a BR without any parameters and it will run successfully if we run it manually from theData Management menu. However this same integration will fail with the following error if we schedule/run it from the Task Scheduler. Here is the error we see in the Task Activity Log:Summary: Error processing Data Management Step 'Import DB2 Audit Checks'. Unable to execute Business Rule 'DB2_DataAudit'. Select a valid workflow profile... Any thoughts? Not understanding how it runs ok manually but has an issue if the Task Manager runs it. Thanks!

Hi All, How do i get data from Cognos into OneStream? I'm building a Fleet CV report, which uses two metrics -- FUR (Fleet unavailable to rent) and UPA (Under Performing Assets), which is available in Cognos. I'm assuming that I need to built a data adapter, or a manually upload the data.   Any suggestions would be great.   Best, Mustafa     

Do we have a way to transfer a file within OneStream (a pdf report), and automatically import into a public folders.  What will be the file-path to that shared drive in OneStream.       Any ideas will be appreciated. Thank you!

Hi is there a way i can load a on premise file to onestream file explorer automated. 

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 

I have created a cube view that I am having issues with some of the rows not totaling correctly. The cube view is designed to display an income statement. Some background on the cube view. It has 2 columns. 1 column has the member filter set as "T#|!ML_Year!|.TreeDescendantsR:U8#DerivedData:Name(|MFTimeDesc|)" so that each month and quarter can be displayed for the year chosen. The 2nd column displays the YTD amount for the year chosen and is written as "T#|!ML_Year!|:U8#None."   The issue I am having is that I have 1-3 rows that are not adding correctly for each quarter. As an example, Month 1 has $500, Month 2 has $500, Month 3 has $500.00 and the total for Q1 is being displayed as $1,000 instead of $1,500. I am only experiencing this issue when I use a different scenario other than actual. I have run a consolidation on each scenario and still experiencing this issue. Does anyone have any suggestions?

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,I am looking to see how other OneStream clients have designed their labor reporting. Do you use specific accounts, do you have a specific dimension, etc? 

Hello,I am wondering if anyone has eliminated a dimension and what that scope of work looked like for you. We have a Labor dimension we want to eliminate and instead we will create new accounts in our Account dimension. Looking for insight from anyone who has taken this on before. Thanks!Regards,Ronnie Karpinski

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