Shape the Future of OneStream Training with our Quick Survey (Gift card available!) Take Survey
Notification
Recent Activity
Export Invalid intersections including validation messages
Hi, I'm aware that from the Validate workflow step, the full list of invalid intersections can be exported as in the picture below (right click > Export): The Validation messages are not included in the export. Is there a way to export the full list of validation messages together with the invalid intersections? Thank you
The OneStream Podcast: Partner Spotlight - AMCO Solutions Out Now!
1 MIN READ On this episode of The OneStream Podcast, Peter Fugere welcomes Jason Call from AMCO Solutions to discuss the growth and success of AMCO as a partner of OneStream. The duo discuss the innovative solutions AMCO has created, implementation strategies, the integration of AI, and the importance of customer engagement.
Export Cubeview with only the columns defined
Hi All, I am trying to export a cubeview using FdxExecuteCubeView, but I get every dimension even though my cubeview only shows 4 dimensions. What is the best way to export a cubeview to retain its view. I want to export multiple cube views and load them to a table so that I can have all of the cubeview data exported through one Data Adapter call via the rest API. Right now, I export one view I get 3 million rows, but when I aggregate it to the level in the cubeview I end up with 28,000 rows. I'd like to avoid exporting 12 million rows if possible. Thanks, Scott
Build on a Solid Foundation: A Guide to OneStream Reporting
3 MIN READ When the business shifts, aligned reporting must shift with it. That’s the real power of OneStream. Reporting isn’t a stack of disconnected spreadsheets or one‑off formulas—it’s an extension of how your application is designed. When your reporting is structurally aligned to the platform, changes don’t break things. They cascade cleanly. And that’s where OneStream is fundamentally different. Three Simple Ideas That Make OneStream Reporting Stand Apart 1. It’s Connected to Your Application Design Most reporting tools sit outside the system of record. OneStream reporting is built from your metadata, dimensions, and cubes—not around them. That means every report inherits the same governed structures your business relies on. Why this matters: When dimensions evolve, your reports evolve with them. No buried logic. No divergent definitions. No chasing down why two versions of the same report don’t match. This creates a level of consistency and trust that’s hard to replicate elsewhere. 2. It’s Built for Reuse—Not Redo OneStream gives you powerful capabilities like: Member Filter Builder Parameters and Parameter Types Reusable calculations and formatting Performance‑tuned Cube Views These aren’t just features—they’re multipliers. You build reporting logic once, then apply it everywhere. When a new request comes in, you’re not reinventing the wheel—you’re assembling components you’ve already created. Why this matters: Scaling your reporting ecosystem stops being manual work. Changes become simpler (and less expensive). Reusability becomes your default operating model. 3. Multiple Delivery Styles—All from One Source From polished financial statements to quick analysis, OneStream supports: Report Books for packaged, repeatable reporting Cube Views for structured, governed data grids Quick Views for fast exploration Spreadsheet / Excel Add‑In for familiar, governed self‑service Different stakeholders, one platform. Different needs, one source of truth. Why this matters: You reduce version sprawl. You enable self‑service without sacrificing governance. Users get what they need, without breaking anything. Bring It All Together: A Reporting Skill Set That Scales OneStream reporting is powerful—but the real value shows up when you know how the pieces work together. That’s exactly what OneStream Essentials: Building Basic Reports is designed to teach. What You’ll Be Able to Do After This Course ✔ Build Cube Views that align to metadata and cubes Ensure your reports reflect your business structure—not personal logic or ad hoc selections. ✔ Use Member Filter Builder for dynamic, reusable selections Avoid brittle member lists that break when metadata changes. ✔ Add parameters for flexible, user‑driven reports Let users explore data without creating endless “copies” of the same view. ✔ Apply calculations and formatting that improve clarity Surface insight without compromising maintainability. ✔ Design performance‑conscious layouts Build reports that run fast and scale. ✔ Assemble and distribute Report Books with confidence Create packaged, repeatable statements and reporting bundles. ✔ Use Quick Views and the Excel Add‑In for governed self‑service Give analysts flexibility while maintaining one source of truth. Why This Course Matters—No Matter Where You’re Starting If you're implementing OneStream for the first time: You’ll learn the foundational patterns that prevent rework, reporting debt, and inconsistent logic later. If you're joining an established OneStream team: You’ll gain the skills to understand, maintain, and extend the reports you’ve inherited—confidently and correctly. OneStream’s reporting isn’t just a set of tools—it’s an ecosystem designed for clarity, alignment, and scalability. When you understand how Cube Views, Member Filter Builder, parameters, Report Books, and the Spreadsheet/Excel Add‑In work together, you can deliver reporting that grows with the business instead of slowing it down. The OneStream Essentials: Building Basic Reports course teaches you exactly how to do that—hands‑on, step by step—so you can build reports that are fast, flexible, and trusted across the organization. Limited-Time ILT Promotion: Save 15%! Take advantage of our exclusive Instructor-Led Training (ILT) promotion—register for the Building Basic Reports course before March 31 and receive 15% off your enrollment! Simply enter promo code ILT15%Q1_2026 at checkout to claim your discount. Don't miss this opportunity to boost your skills and save. Ready to explore? See the course in Navigator and log in to secure your spot now. Building Better Reports
Extensible Documents Cubeview margins
Hi Everyone!, I have been unable to set margins in a cubeview in a extensible document. Even though, the report margins in the cubeview settings are set and the argument IncludeReportMargins is set to true as can be seen in the attached images. But no margins are shown. Thanks for you help.Genesis Cube View with Drill issue
I've been working on getting up to speed with the various Genesis content blocks and am having trouble with the Cube View With Drill block. When I try to select a cube view, the tree view only goes down to the Cube View Group level, not the Cube View level. I was able to tweak a business rule to allow it to select a specific cube view, but then the drill doesn't appear to work when I select a cell to see the details. I'm certain there is data that can be drilled down to, but nothing changes when I click various cells. I've even tried setting the cube view to show a base-level intersection and confirmed that I can see a number that is the same in stage. Anyone seen this issue yet or have any troubleshooting tips?Planning: Daily Data to Daily Import to a Monthly App
Have you seen a KB / post that met the requirements for daily data? Please share your experience / practical advice to help us meet daily data requirements. - for Planning - flat files: Daily Data per Month - flat files: Daily Import - Reporting by Day by Month Thank you folks for sharing your expertise.
How to write Smart Integration Function in Assembly
Hi, I have created one one Smart integration function in to transfer file from sftp server to share point server. can we use smart integration function as a file or use existing smart integration function as dependency , not sure just need suggestions.Tech Talks After Hours - OneStream Fitness
In the kickoff session of our OneStream Fitness series, Tom Linton and Roland Galli lead you through a “rule‑writing workout,” breaking down the essential dos and don’ts to help you build stronger form and healthier solutions on the OneStream platform. To receive OnePoints for watching this Tech Talk video, please visit the link below: Tech Talks After Hours: OneStream Fitness
