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. AntonySolved68Views0likes5CommentsSmarter 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?42Views0likes0CommentsEnvironment Monitoring Graph Not Displaying Any Values
Hi everyone, I've been trying to use the Environment Monitoring feature, but for some reason the graph doesn't display any values. The interface loads correctly and I can select different metrics and time ranges, but the chart area stays empty—no lines, no points, nothing. Has anyone experienced this before or have any idea what might be causing it? Any tips on how to troubleshoot or configure it properly would be greatly appreciated. Thanks in advance!6Views0likes0CommentsExcel 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 NT98Views0likes1CommentOneStream Server Configuration
Hi all, while configuring a local OneStream instance, I know that I have to copy the "Encrypted Connection String For Server" from DataBase Configuration, putting it into the Application Server Configuration File, in the "Database Server Connections" item. I see that there's also a "Is Connection String Encrypted" flag, so I suppose I could set a clear connection string. Is not clear which would be the format of an unencrypted string (I took a look in the Installation Guide but I wasn't able to find what I was looking for...). Since this is a local development instance, there's no need to secure it... Could someone share this knowledge (or point me in the right direction) ? Thanks a lot FabioGSolved49Views0likes2Comments