Spreadsheet tool in v8.5 - does it work?
Trying to confirm if the spreadsheet tool in v8.5 is working for anyone in the following manner... Created dashboard with the spreadsheet tool. The page renders fine... However, when doing something as simple as Save As, the following message is generated. Excel file is defined in the configuration. One client mentioned this, so I tested this on another client with the same results. Heard this is fixed in v9.0. Is this correct or am I missing something? Thanks for any input! Ed Puente34Views0likes1CommentOneStream 9.0 file explorer error
Hello, I installed OS 9.0 on premise version recently and I am having the following error when I try to upload a file: You can find below the error details: Unable to load file.An error has occurred. BadRequest. User Interface Stack Trace: at OneStream.Client.Api.FileExplorerServiceReference.FileExplorerServiceClient.UploadFileFromStream(XFFileTransferRequest request) at OneStream.Client.Api.FileExplorerServiceReference.FileExplorerServiceClient.<>c__DisplayClass370_0.<BeginUploadFileFromStream>b__0() at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) Do you know what is the cause of this issue? Thank you in advance. AntonySolved68Views0likes5CommentsChanging the UI Language
Hi Everyone, I know we can use culture settings to show users localized member descriptions, or XFStrings to change text in dashboards, but what defines the display language of the core UI? If I wanted the desktop or browser app's UI to render in another language (e.g. French for certain users), what options do I have? Thanks17Views0likes1CommentClear ALL Data related to a specific Member.
Hello everyone, I'm just wondering if there's a method or a way to delete ALL Data with a click of a button. I know about data management steps and the use of it along with the finance BR. So my concept and idea is that, I allow the user to select the member (step 1) or list of members (if step 1 is good). Then the user can click one button to delete all data. Why I want to do this is because let say the user want to delete a certain member, it will be easier for the user to do so. I tried to retrieve all the cubes that I have in the application and changing it via the scriptbuilder/databuffer method and setting the cell to 0 but the concept of DataUnit do not allow us to do so. Thus, I am here seeking for guidance and wisdom from the community. :) Thanks!Solved54Views0likes2CommentsHow to assign images to Tree View nodes when not using the Default Workspace
I have a dashboard that uses a Tree View. Its in a named workspace. The only way I can get images to work with it is to upload the images to a Default Workspace. Is there a way to reference my images in the workspace where the Tree View is?2.5KViews5likes7CommentsSmarter Data Loading: How OneStream Transformation Rules Automatically Handle New Members
In the world of Enterprise Performance Management (EPM), clean and accurate dimensional mapping is essential for a reliable reporting process. Fortunately, OneStream makes this easier through its robust Transformation Rule framework, which intelligently handles new dimension members automatically. Whether it's a new GL account, cost center, or entity, OneStream’s transformation engine ensures that new data doesn’t derail your process, even before user intervention. 🔍 Key Benefits Dynamic Member Detection When a new source member enters the system—say, a newly created account in the ERP—OneStream flags it immediately as “Not Mapped” in the staging area. This provides the user or administrator with a clear indication that attention is required. Mapping can then be quickly added or adjusted to keep data flowing seamlessly. Centralized and Flexible Maintenance Transformation rules support Wildcard and Dynamic Mapping, making it easy to set default routes for unknown members (e.g., directing all new accounts to a placeholder for Unmapped Accounts). From there, consultants or admins can reassign the correct mappings when ready. This approach provides control without interrupting the load process. Built-In Mapping Validation There’s no need to build dashboards or manual reports to detect mapping issues. OneStream’s Data Source and Transformation Rule editors include built-in validation tools to identify unmapped or incorrectly mapped items before they affect results. This enables early detection, faster resolution, and reduces dependence on visual checks. ✅ Why This Matters By leveraging these out-of-the-box capabilities, organizations save time, reduce risk, and streamline their integration workflows. Consultants can focus on higher-value tasks instead of constantly updating mappings, and end users can trust that data loads will highlight issues automatically, before reporting is impacted. Please keep it simple. Do you agree that OneStream handles what it's built to do?42Views0likes0CommentsData Management Export configuration
Hi all, I'm working on a Data Management to "Export Data", launching it from a Dashboard. Everything works fine, since filters (Cube, Entity, Account, Flow, etc) can be parametrized through Parameters. Is there a way to parametrized also the Options such as "Include Zeros", "Include Member Descriptions", etc ? I see that at UI level I can only choose between True and False, but I'd like to manage them from my dashboard. Thanks in Advance FabioG21Views0likes0CommentsExcel Add-in not working for one user
Dear Users: I had just one user who was not able to get their instance of Excel Add-in 8.4 for various workbooks. However, if the very same workbook was emailed or shared with another users it worked just fine. The main issue is that the user could not "REFRESH" the sheet. Eventually, the Excel add-in started to work. Has anyone experienced this in the past? What was the solution? This is the error message: Description: Object reference not set to an instance of an object. Error Time: 1/17/2025 5:49:51 PM Error Level: Error Tier: AppServer User: xxxxxx Application: OneStream_Prod App Server: vmPRD1int000001 App Server Version: 8.4.0.16413 App Server OS Version: Microsoft Windows NT98Views0likes1CommentCombo box cell type not working in Excel
I am working on in OneStream V9. I have a workspace cube view with a combo-box cell type. The cube view works fine in the application, but when I open the same cube view using the Excel add-in the combo-box drop down is not active. Any ideas on what I should check? Thanks.24Views0likes1CommentCompilation Chain issues
Hi all, I wrote a bunch of BRules and a couple of Assemblies (in different workspaces) that work together to perform calculations. So in the end I have a dependency chain like this: BR => Assembly => Assembly Things works like a charm. Sometimes, after I made changes to an Assembly, I get a weird error saying that OneStream cannot find my assembly. While this is true when it cannot compile correctly (due to errors), it doesn't make sense to me when it compiles fine. Even if I compile my assemblies before I run the BRules, sometimes it happens. I'm trying to find out an explanation and I thought that: I run the BRule and OneStream think that Assembly1 - a dependence - is "old", so.... OneStream start compiling Assembly1, and, while compiling it, OneStream think that Assembly2 - a dependence - is "old", so.... OneStream start compiling Assembly2 Maybe these compilations are running async and in parallel... And, maybe, the last compilation takes too much time, taking the first one returning the error. This is just an idea that could explain this issue, but I'm quite sure this is the right way: when I started working on OneStream, my code wasn't affected, IMHO because the assemblies were small enough to be compiled in a reasonable time. But now they are growing up, and the compilation time is growing too. In any case, I'm wondering it there's a way to solve this annoying issue: I often have to (re)launch the same BRule and, on a customer's perspective, seeing a compilation error (even if fake) doesn't make a good impression. Thanks FabioG52Views0likes2Comments