Announcement
ABC
Recent Activity
XFGETCELL #REFRESH
Certain users aren't able to refresh sheet containing XFGETCELL. Only shows #REFRESH. In OneStream task activity, it shows that the task has failed with an error message "Summary: Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0, -1." This should not be related to access since I was able to refresh sheet using another profile with the same roles.
Unlock the Power of Platform v8+: Your Upgrade Hub Awaits
1 MIN READ If you're planning—or even just considering—a move to OneStream Platform v8+, there's one destination you can't afford to miss: the Platform v8+ Upgrades Guide. Whether you're a seasoned admin or a business user navigating the upgrade path, this group is your go-to resource for everything v8+. Why It Matters Platform v8+ introduces transformative enhancements—from the modern BrowserUX experience to tighter integration with OneStream IdentityServer (OIS) for seamless authentication But with great power comes great preparation. The upgrade touches everything from DLL handling and business rule compatibility to solution updates and client API configurations What You’ll Find FAQs and Guidance: Clear answers to common upgrade questions, including DLL behavior and ERP Connect compatibility. Solution Compatibility: Detailed documentation on which solutions require updates and how to approach them Community Wisdom: Real-world questions, answers, and tips from peers who’ve already walked the upgrade path. Get Started The Platform v8+ Upgrades Guide isn’t just a repository—it’s a living, breathing support system. Dive into the articles, join the forums, and prepare for an upgrade. Whether you're upgrading from v7.4.2 or prepping for v8.2, this group will help you do it smarter, faster, and with fewer surprises. If you're looking for the previous V8 Upgrade forum, please know this has been archived and been replaced by the V8 Upgrade Guide.Execution Timeout Expired
Error Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated. (SQL Error Number -2146232060, -2, 0, 3621). The wait operation timed out This happened after running Load and Transform for one of my import workflows. Any idea what's causing this? It stops at the PostFileArchives stage:
Restricting Data Loads Outside Workflow Time Period – Excel Quick View / XFset
Hey Team, I’ve observed that users are currently able to load data via Excel/Spreadsheet tools (Quick View / XFset) beyond the defined Workflow Time Period range for any scenario. This behavior persists even after setting the following Application General Properties to False: Allow Loads Before Workflow View Year Allow Loads After Workflow View Year Despite these settings, the restriction does not seem to be enforced, and users can still submit data outside the intended time range. Could you please advise if there are additional configurations or security settings required to fully restrict data loads outside the Workflow Time Period—especially when using Excel-based tools? Any guidance or best practices would be greatly appreciated. Best regards, Yogesh Kumar Goyal
Dashboard component/business rule
Is it possible to do a live character count using a text box and label component inside of a business rule that counts characters as they are being typed into a text box component that is used in a dashboard? The contents of this text are written to a relational table but as for the character count, I want to do that live BEFORE I write the contents to a relational table. This is on an 8.4 application.
Supplied Parameters in Workspaces
Hello, I have a button which is fed from a List Box seen below Upon clicking this button, I would like Users to navigate to another Dashboard where the label component and cube view open with this button selection. Are supplied parameters the way to accomplish this? If so, what are the correct configurations to achieve this. Thanks for your help!
Integration from MS SQL DB to OneStream
Hi Dears, Could anyone please provide me the practical steps to Integrate the MS SQL DB to OneStream. we are at presently testing with the data integration to learn the integration. Kindly provide the real time steps which can work Onestream - On-prem envi SQL DB - Local host regards, BCGRemovezeros in getdatabuffer
Hi, We have a seeding rule that is copying zeros: sourceActualsBuffer = api.Data.GetDataBuffer(DataApiScriptMethodType.Calculate,S#Actual_Opco:U5#None,False, destinationBuffer) I am trying to change it so it does not include zeros, by applying the removezeros function: sourceActualsBuffer = api.Data.GetDataBuffer(DataApiScriptMethodType.Calculate,"RemoveZeros(S#Actual_Opco:U5#None)",False, destinationBuffer) When I do this, I get an error see attachmement. I tried to change the quotes RemoveZeros("S#Actual_Opco:U5#None") but then i get a different error when validating. Could not find anything in the reference on how to fix this. Anybody can help?
