Community Highlights: August 2024
August 2024: Back to School! And just like that, we're saying farewell to August! With September comes our new moderator: MG. MG aka Matt has been with OneStream for nearly 7 years and brings a pletho...
Blog Articles
Maximizing Cube Utilization in OneStream Applications
Maximizing Cube Utilization in OneStream: Expert Perspectives Welcome to the wild world of OneStream applications, where Cubes are the undisputed data management and reporting champions. Buckle up bec...
Community Highlights: June 2024
July 2024: Summertime That’s a wrap only July! As expected, July was slightly less active than other months with everyone enjoying their summer holidays. As the summer peaks and temperatures soar, we ...
The Magic and Math of C#Top
I hear that you’ve bought the OneStream Administrator Handbook – well, well, congratulations on taking the steps that will (hopefully) make your life as an Administrator easier! The book is brimming w...
"Top N" reports - no code required!
It has been a quiet Tuesday morning at Badabing Ltd. Had some decent coffee, checked all reports went out last night, and basked in the glory of a sea of green "OK" calculation statuses. As you ponder...
Community Highlights: June 2024
June 2024: The End of an Era! It's bittersweet as we say goodbye to our fabulous moderator @JackLacava! While we're incredibly happy for him and his new role, he'll be sorely missed. We are immensely ...
Preparing for Direct Connection to OneStream
One of the most common if not the most common requests when setting up OneStream is to have a direct connection from an ERP such as Oracle, Peoplesoft, and/ or Netsuite to OneStream to allow for data ...
Rules about Rules: Tips and Calculations Optimization
The OneStream platform is based on the Microsoft .NET Framework, as is the OneStream Business Rules Engine. VB.NET has become the logical choice for Business Rule syntax, and is also a popular program...
Community Highlights: May 2024
May 2024: Longer Days! As the sun shines brighter and the days grow longer, we are through the vibrant month of May in North America and on the heels of summer! We have just wrapped up the highly succ...
Pivot and Submit Data through a Spreadsheet with Table Views
Background We were recently engaged with a client implementing a Thing Planning solution, which would manage thousands of line items for their planning process. The client wanted to be able to look at...
ONECommunity Highlights: April 2024
April 2024: Spring Has Sprung The birds are singing, the trees are blooming and spring is in full swing in North America. It'll be summer before we know it, and for a lot of us that means taking some ...
Data import through external API services - integrating with Dynamics 365
In this article I'm presenting a working example of integrating our beloved Platform with one of most widely used ERPs in the world: Dynamics 365, specifically the FinOps suite. This said, the solutio...
ONECommunity Highlights: March 2024
March 2024: Incoming Total Solar Eclipse We're days away from a total solar eclipse in North America . The next total solar eclipse in the contiguous United States won't be visible until August 23, 20...
Log Like a Champ with JSON
In a previous post, we saw how we can build a utility library to help us with typical logging tasks. However, there is a common problem when trying to represent the state of our processes in logs: it’...
How to upload Flat Files to a Custom Table
Table Data Manager: OneStream has a Marketplace Solution, called Table Data Manager, which allows users to create custom tables where data can be loaded and updated. Table Data Manager has a feature t...
Log like a champ with OneStream
When I made the move to OneStream, one of the first things I understood and appreciated was logging. It is such a welcome change from legacy systems! You can easily log anything: text, the value of a ...
ONECommunity Highlights: February 2024
February 2024: An Early Spring Spring as sprung! As the days get longer, we at OneCommunity want to thank all our members for their activity in February. The Community continues to grow - and it's all...
BiViewer Parameters Demystified - pt 2
In Part 1 of this short miniseries , we have seen how we can pass values from traditional Dashboard Parameters into Bi Viewer. But what about going the other way around, i.e. getting values from Bi Vi...
BiViewer Parameters Demystified - pt 1
We know that OneStream users love BiViewer components. They look nice, are dynamic and interactive, and bring tons of baked-in functionality - ready to be leveraged with minimal effort and no coding. ...
So You Want to Learn VB.NET - pt.3
In part 1 and part 2 of this series, we have seen how to handle VB.Net variables, call existing functions, and manipulate basic data-structures. This is enough to write simple scripts or member formul...
ONECommunity Highlights: January 2024
January 2024: A Busy Winter It's a fresh new year and winter has definitely set in. Yet despite the cold, things are heating up on OneCommunity. The cold weather might be keeping us inside, but it's c...
Historical Restatement, No Code Required!
In today’s modern business world, a company’s organization structure can move more frequently than anticipated through changes like acquisitions, divestitures and mergers. The organization’s structure...
A Year in Review: 2023 Highlights
It's Time to Unwrap 2023! This past year was one of growth. There are so many different metrics to look at to determine the overall health of a community, including new posts, logins, views and even k...
Beyond Flat and Delimited Files: How to Load XML or JSON Data
Picture this: it's a bright, sunny morning, and you're spinning on your chair, enjoying the warmth of the sun on your face. Suddenly, your boss approaches you with an intriguing question: "Hey Om! Can...
ONECommunity Highlights: December 2023
Cheers to a Fantastic 2024! Let's raise a glass to the dawn of the New Year - a chance to refresh, renew, and revive. Or perhaps it's the time to draft a few well-meaning resolutions? Before we comple...
How to build a Multi-Select TreeView
While building a Dashboard, you might have the need to provide a widget for the user to select a bunch of members at the same time. This can be achieved in a number of ways. If your requirements are s...
Introduction To Tree Views
This post is an introduction to Tree Views in OneStream Dashboards, a type of widget that can render hierarchical data. Their complexity can vary, as you will see below, but once mastered they will be...
How's your Week?
In this blog, we are going to discuss weekly reporting in OneStream and answer some frequently asked questions when considering how to handle weekly data in the system. Within the OneStream delivery t...
ONECommunity Highlights: November 2023
It's the Holiday Season! Here at the ONECommunity we wish you and yours a safe and wonderful holiday season. The New Year is right around the corner as 2023 winds down -- which means a special year in...
Changing Signs in OneStream
Any data loaded in OneStream has to be logged against an Account. Typically, the Account Type property of the account member will determine how the data is treated, but there are a number of other fac...
