OneStream Platform Forums

Hi everyone!I am working with a Pivot Grid dashboard item in the BI Viewer. I am investigating about the possibility of formatting the Excel export of this component. Currently, the exported file does not retain the formatting applied within the BI Viewer, resulting in a very non-user-friendly layout, with fixed column widths. Are there any options available?Any insights will be highly appreciated! :) Thank you!Have a nice day,Andra

We're currently evaluating the upgrade to OneStream 9.3.1 and noticed that this release requires a move to .NET 10, which appears to be a more significant prerequisite compared to previous 9.x upgrades.For those of you who have already completed or are planning the upgrade, I'd appreciate hearing about your experience and any lessons learned.Questions for the Community1. Infrastructure & CompatibilityDid the .NET 10 requirement introduce any challenges in your environment? Were there any compatibility issues with existing servers, middleware, integrations, or third-party software?2. Upgrade EffortHow much additional effort did the .NET 10 migration add to the overall upgrade? Was the .NET upgrade straightforward, or did you encounter unexpected issues during installation or testing? Were any rollback plans needed? any issues occur and popup related?3. PerformanceHave you observed any performance improvements or regressions after moving to 9.3.1 and .NET 10? Were there any noticeabl

We are using a custom built dashboard to import multiple CSV files to several Import workflows at the same time. Currently the user has to select import separately for each file as the prompt window does not support multi-select. Then all imported files can be Validated and Loaded.The dashboard looks currently like this: Our business thinks this would impact our short closing times severely as users have to do this multiple times after corrections are made and for multiple companies. Rough estimate is about 50 users impacted each closing.Calling a different Windows API functionality should not be a huge change and this could potentially save us a lot of headaches. At the moment we cannot use direct connection to our ERP systems as they are too varied across the companies, so a standardized CSVs are our only option. 

Hello, I am trying to set up the Cube Data Manager solution from Open Place in my working production application. Currently it is all loaded up, but I need a little help figuring out how to add the environment to it containing the applications that I want to work with. Please see pictured below.   Thank you, Jeremy Morgan

Hello everyone,Is it possible using a business rule to make a quick certification for a Certify Workflow?I was abel to complete the Certify Workflow task using business rule but the certification status remains rejected.Thank you in advance for your help.Regards,Antony

Dear Community,   It is very easy for a user to add comments on a given cell, using data attachments : However, what are the reporting possibilities for such comments ? Could we use them in dashboard, for instance to be shown as footnote of a dashboard ? Or could these be used as footnotes in pixel-perfect pdf documents generated from a cube view ?   Many thanks,

Hello OneStreamers,The purpose of this note is to share my end-user experience getting the new Developer Studio installed and configured.  I hope it helps you.What is Developer Studio?  This is a new tool to move code between your local file system and OneStream. Initial SetupDownload Developer Studio from Solution Exchange - OneStream Software Install Developer Studio by running the executable Launch Developer Studio and select File / Download OneStream Reference Assemblies… and store both versions them in a common directory such as c:\nuget  Register Sources  At the command prompt run this command  dotnet nuget add source c:\nuget --name LocalRepo Confirm the source has been added by running the command dotnet nuget list source  This directory should be the same one that has the reference assemblies downloaded in the previous step.  It can be anything, but in this example it is “c:\nuget.” Congratulations!  You have installed Developer Studio and configured your local machine

We're working on a solution, where users can enter and view a date through a Cube View using the Cell Type Date. The challenge is how OneStream handles date's (datetime) with time-zones. When a date is saved to the backend, it's converted to UTC time-zone. The Date component in the Cube View is also Time-Zone aware, so that it uses the local time of the user, to convert back from the backend UTC to local-time. The challenge with this is 2 fold: 1) Assuming we would calculate a rent for a given period. The user, based in CET time-zone, enters 2022-1-15 using the Gridview. This date is converted to 2022-1-14 as UTC (2022-1-14 23:00:00). Using a Custom Calculate method to calculate the rent from start (2022-1-15), now adds one day more, as the server time is UTC. (don't mention Daylight Saving Zone)  2) If another user, based in US Central, is reviewing data in the same Grid View (and same POV), this user will see a wrong date, as the server UTC date, is converted to this user's loca

I cannot find any literature on this - I have a custom calculate rule, how to I call it from a DM step? This is what I have in DM step, but I keep getting the below error: Below are some additional info on my set up: Thank you.

Hi, I have created an admin dashboard for forecast. I want a text box that shows parameter values, but there is a separate parameter for each Scenario. ScenarioParameterForecast_MarCopyLatestActualsToFCT_MarForecast_JunCopyLatestActualsToFCT_JunForecast_SepCopyLatestActualsToFCT_SepForecast_Dec CopyLatestActualsToFCT_NovCopyLatestActualsToFCT_Dec The parameter has either value False/True and depending on the value, the business rules that are initiated via the dashboard will do different things.  The dashboard is shared between the WFs/Scenarios.How do I create a text box that gives me the parameter name and value?e.g. when I use WF Forecast_Mar I want the textbox to say: "Forecast_Mar = (Value)"December has double parameters why I need both to be shown, "Forecast_Nov = (Value), Forecast_Dec =  (Value)". Is it possible to do this using standard functionality for parameters (e.g. create a new parameter that picks the values from the others that I then link in my dashboard). I

How can we format the Header Row of a BI Viewer Grid (ex background color, bold, etc)? I see how to conditionally format the data rows, but I don't see anything for the header row....

Does anyone know of any information related to the new VLWDataRecord tables that are new in OneStream 9.3?There is nothing in the release notes and nothing in the documentation. Teams are seeing issues with the Data Records tool on the system tab. The vDataRecordAll View excludes those tables (and there is no vVLWDataRecordAll view at all). Has anyone tested solutions that may access data tables more directly (like FDX) to see if there are issues? Does anyone know how OneStream is choosing where to store data? It appears that some data is going to the new tables, but some data remains in the old tables.We have some nervous team members and nervous clients looking to upgrade, but unsure of the implications of this change. Honestly, I can’t blame them, since fundamentally changing the database schema for how your cube data is stored in OneStream without any information is a bit nerve-wracking. We’d appreciate any conversation related to this topic so the community has a better idea what

I installed the wrong Excel add-in on my new computer (7.0.1 when our tenant is only compatible with 6.6.0 or lower). Now, when I open Excel and try to logon, I get the below error message. I have figured out that if I manually disable the OneStreamExcelAddin.XFFunctions and completely close out of Excel then, when I restart it, I'm able to logon. The annoying part is, if I forget to disable it and close out of Excel, the next time I use Excel I have to go through that whole process of saving and closing all my workbooks, disabling the add-in, restarting Excel, just to use the add-in. I'm thinking there must be something leftover from the previous install that is causing this and I've tried to completely wipe everything from the initial install before installing the correct version but to no avail. Has anyone else experienced this and know what steps I can take to remediate? (I should also note that I made the same mistake on my old computer and had the same issue, so this does not jus

Hi everyone, I have a question regarding confirmation rules - is it possible to run confirmation rules from outside a workflow via a dashboard button or some other method? Some of our users who would like to see the status of their confirmation rules without having to complete the form and workflow. Currently, they have to mark all forms as complete, complete the workflow, and process the cube to see confirmation rule status. Then, once they see which rules are failing, they have to revert the forms workflow, then revert individual forms - it seems like a lot of extra steps. The forms nodes on our workflows are set up as "Form Input, Process, Confirm, Certify". One possibility we've considered is a dashboard where users can click a button that runs the confirmation rules for their current workflow, then return the status of those rules in a grid view, all without having to complete the forms workflow. I've created a grid view to show confirmation rule status for the currently selected

Dear all, We have a case in which the client needs several copies of the same CV in excel, but having different parameters (selecting an account node) for each CV. Is it possible?We know that defining the parameter internally in an excel file helps to avoid asking for that parameter again.We tried to put 1 CV connection per sheet and one parameter per sheet, but it seems that only the 1st parameter is read and then updates all CV connections following this 1st set parameter. Do you have any idea how to deal with this in order to keep different parameters for each CV connection?Thank you for the help.Best regards,Carlos

Hello ! I would like to bring some animations on my dashboard.Anything from animated gif, autoplayed videos, CSS code ... that could be useful !I have tried adding "file viewer" for an MP4 video but the "auto play" attribute doesn't seem to work. I've also tried animated gif, but these are not played as well.Do you know any ways to overcome static objects on the homepage ? Regards,

Hi All, We are using the OneStream 'cloud' solution with the desktop application required to be installed to access the OneStream functionalities. We would like to perform load/performance testing for the application with 250+ users to check its performace under the load. Have anyone done performance or Load or Concurrency testing for OneStream cloud application which is accessed through OneStream desktop application? If you have done this testing before, please share the performance or load testing tool and protocol used for testing the desktop application of OneStream with cloud solution. Your help will be much appreciated. Thanks!

Dear community, I currently have an html document which is located in the file Explorer under "Documents/Public" folder. I am trying to get this HTML document to be presented into the components, embedded in a dashboard. However, with either a Web Content component or a File Viewer component (which will pinpoint to this specific file in Application Database File, as soon as I open the dashboard, it will load the html page into my default browser... I am using OS v8.1 ... is it a known bug or the expected behaviour ? What is even more strange, directing the Full File Name to a URL will correctly open a document in a dashboard ... Regards,

I am unable to delete a Cube Root workflow for AOP due to an issue related to a workflow profile.The error occurs whenever I attempt to delete the workflow profile.I have already reset the scenario, checked all the data record tables, including the DataUnitCashStamp table, and even used a Custom Calculate BR to set the entity value to 0.I suspect that a form associated with this workflow profile was completed previously, and its log or reference still exists somewhere. Despite thorough checks, I am 100% certain that there is no data associated with this entity in any table.How can i delete the log associated with this workflow profile so i can be able to delete it  ? I need to merge AOP and Forecast under the same suffix in the cube property, unless I can delete that workflow profile, i won't be able to do that. I appreciate the help !! 

Hello to everyone. Does anyone know how to build in Excel Add-ins for Task Manager? Our OneStream version is 8.2.2.16127? Guidance for this version provides the step-by-step instructions how to set up Add-ins for Word and PowerPoint, but not for Excel Add-ins.  Our Task Manager version is PV800 SV100. If to be very specific, we are looking for the opportunity to install Excel Add-Ins to link the preparation status from excel file to particular task in Task Manager. For example, if we have the excel file somewhere outside OneStream (on Sharepoint), and when the work done inside this file, we can push built-in "Complete" button in this file. The completion status from this file automatically forces the change in the preparation status in Task Manager for this task, which is linked to this file through the action type functionality in Task Manager.  Does it sound real? Could it be potentially implemented from technical point of view?   Thank you in advance fo

Where can I download CPM Express? I checked the Marketplace but couldn’t find it there. Is it available for partners yet?

Hi,I need to check in a Table View if certain column values are dirty and I've noticed that when you call the IsDirty() function on any decimal type column (and this only happens on that type), it always returns 'true' even though no changes took place.Because of this i need to manually parse the value and check if the originalValue is different from the current value.At this point I was wondering if this behaviour is intended or not, it seems odd that IsDirty() returns the correct value for every type of value BUT a decimal one.Any clarification on this matter is appreciated, thanks in advance. 🙂

Hi,Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views?  We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view.  There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks

Is it possible to create rules in Visual Studio?

I uploaded the XFJ Excel template with the "Balanced by Entity" Journal Type. However, OneStream set back the Journal Type as "Balanced" instead of "Balanced by Entity after I imported the template . "Is "Balanced By Entity" not the correct selection? Thanks,