Announcement
ABC
Recent Activity
XFGETCELL(), XFSETCELL() PERFORMANCE
Hi all, Every forecast cycle we get the same performance complaints from the same region group of users. They are always uploading massive amounts of data and refreshing massive amounts of data in the same workbooks using the XF functionality in Excel. To be clear, we have tried multiple times to convince them that they should be importing that data via CSV and advising that they will not get the same performance using the XF functions. We have also tried having OneStream re-index the databases before these cycles and we have regular daily app pool recycles. The OneStream data logs really don't show any significant refresh issues (less than 5 minutes usually) but the one user doing all this work is insisting that it's taking hours and hours to finish refreshing and they often have to close and reopen Excel and re-launch OneStream. We have raised multiple tickets and OneStream does not see any back end issues. We have looked at their Excel preferences and tried different options there but no improvement. I am 100% out of ideas so if anyone out there has any thoughts, would love to hear what you've done to resolve these issues. I'm going to post this as well somewhere in the community where Excel discussions happen. Thanks for any advice.
Real-time "Unsaved" status, Intercepting Workflow Navigation
I have a requirement to implement data integrity guardrails on several budgeting forms (Dashboards containing Cube Views/SQL Table Editor). I am looking for guidance on whether the following two features are technically feasible within OneStream: 1. Real-Time "Unsaved Changes" Indicator The goal is to display a status label at the top of the Dashboard that updates to "Data Hasn't Been Saved" the moment a user modifies a cell value (Cubeview/SQL Table Editor), before they actually click the Save button. Question: Is there a way to detect a "dirty" cell state or user input in real-time to update a dashboard component immediately, or are we limited to updating status only after a Save action is triggered? 2. Navigation Warning (Popup on Exit) The goal is to trigger a popup warning if a user attempts to navigate away from the current Workflow Unit or close the Dashboard tab without having Saved or Run Calculations. Question: Is there an event handler available that allows us to intercept a navigation event, and potentially block the user from leaving the screen until they complete the required actions? If anyone has implemented a similar solution or knows which Business Rule events controls these interactions, I would appreciate the insight. Thanks!
Unable to schedule refresh through Power BI Service
Hello OS Community, We are building Power BI dashboards using the new Power BI connector for OneStream. We can successfully retrieve OneStream data through the connector in Power BI Desktop. However, after publishing the .pbix file to the Power BI Service, we are unable to refresh or schedule a refresh from the service. We reached out to Microsoft, and they indicated that this is a third-party connector (Power Query OneStream connector - Power Query | Microsoft Learn) and redirected us back to OneStream. We also contacted OneStream support but have not been able to resolve the issue. I’m curious if anyone has had a similar experience and found a resolution. Below is the error we received: "Unable to update connection credentials. Failed to login with OAuth token, please update the credential manually and retry. Details: [DataSource.Error] Unable to connect to the remote server Please have this information handy if you choose to create a support ticket. Session Id: 0bd10fb7-cdd7-4519-8d3c-244e692fcc4b RequestId: 1faeb721-27d0-4928-aab3-539aeea6d2fd Cluster URI: https://api.powerbi.com Status code: 400 Time: Thu Nov 20 2025 12:42:05 GMT-0700 (Mountain Standard Time)"
Report (PDF) Background Fill Color Not Extending to Bottom of the Space
Dear community, When opening a cube view in PDF, the row height isn't automatically equal to the row header height. As a result, the color in background within the cells isn't extended properly: A workaround is to set a row height, but the problem becomes when we have an header description that would be bigger. How do you handle this at your customers please? Thanks, FlorenceCommunity Highlights: October 2025
2 MIN READ 🎉 Have you explored our latest gem? We’re excited to introduce the OneStream Press Excerpts—a brand-new resource designed to inspire and inform! You’ll find it nestled under the Resources tab in the top navigation. These excerpts are available to everyone completely free of charge, offering a sneak peek into the insights and expertise packed into our full publications. If you’re hungry for more, the complete editions are just a click away at onestreampress.com. 💡 Need a quick dose of knowledge? Don’t miss our QuickTips, released fresh every Wednesday! These bite-sized tips are crafted to help you get the most out of your OneStream experience. Be sure to swing by the Community each week to catch the latest drop. 🎄 As the holiday season approaches, we’re feeling especially grateful for the vibrant, collaborative spirit that defines our Community. Your questions, answers, ideas, and encouragement make this space truly special. From all of us to all of you—thank you for being part of this journey. We wish you a joyful, restful, and heartwarming holiday season. 📈 Now, let’s talk numbers—because the Community is thriving! Here’s a snapshot of October 2025: 👥 42,843 visits and 21,557 unique visitors 💬 99 new discussions, 💡 28 new ideas, and ✍️ 19 new blogs 📊 Reporting took the spotlight as our most active forum, with 18 new discussions Top Engaged Threads: 💬 Most Replies: Restricting access to force Consolidate 👀 Most Views: Workflow Profile Hierarchies: Security Model | Application Security Roles v Workflow Security Most Active Members: 🗣️Most Forum Replies: MarcusH 👍 Most Likes Received: KH1 ✅ Most Authored Solutions: RobbSalzmann
