ONECommunity Blog
Blogs from Experts on OneStream

Blog Articles

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. ...

0 Comments

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...

0 Comments

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...

0 Comments

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...

0 Comments

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...

1 Comments

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...

0 Comments

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...

0 Comments

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...

0 Comments

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...

0 Comments

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...

0 Comments

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...

0 Comments

So You Want to Learn VB.NET - pt.2

As we've seen in part 1, we can manage data in memory using individual variables. However, often you need to handle multiple elements in a similar manner: you might want to retrieve all base members u...

0 Comments

Stop confusion with empty parameters in Dashboards

Tired of opening your dashboard to find no pre-populated values? Frustrated when your combo boxes and list boxes don’t display a value upon runtime? This brief blog post will assist admins/super users...

0 Comments

So You Want to Learn VB.NET - pt.1

If you want to unlock the full potential of the OneStream platform, you want to learn a bit of VisualBasic.NET. Don't be scared! It's much easier than it looks. We'll now cover the basics (lol) of the...

0 Comments

ONECommunity Highlights: September 2023

Time for our Shining Stars! As the calendar turns, we find ourselves in the mysterious and magical month of October. It's spooky season! The forum is echoing with the lively chatter of our community, ...

0 Comments

Cool CubeViews with Custom GetDataCell Functions

"Hey boss, look a this Cube View I made - it shows our EUR Fx rates against all currencies in our app. Cool, uh?" "FX rates we loaded last month aren't cool. You know what's cool?" "... You?" "Real-ti...

4 Comments

How soon the summer ends and September rolls around!

How soon the summer ends and September rolls around. The languid heat of summer is over, and the crisp crack of newly sharpened pencils and the smell of strawberry highlighters fill the air as new rec...

0 Comments

ONECommunity Highlights: August 2023

Fall into our August Highlights! That's right -- we're falling into the next season: Autumn! With the changing of the leaves also comes the end of summer vacations and beach weather. Kids are back to ...

0 Comments

SELECT Like a Boss With Query Parameters

SQL: cross and delight of the IT revolution. If you've been in the game for more than a few years, chances are that you got your hands dirty with database queries once or thrice. OneStream itself keep...

5 Comments

A sneak peek into Dashboard XFBR Business Rules

Have a cube view where the Member Expansions or Time Functions just don’t provide you with what you need? You have this report you need to build and you’re struggling to match the formatting that is p...

1 Comments

What in the World is a Sankey Diagram?!?!?

The second-hardest thing about writing a book is getting yourself to stop typing (the hardest thing, of course, is getting started). Particularly when the book in question covers a topic as broad and ...

0 Comments

ONECommunity Highlights: July 2023

It's August... the Last Month of Summer For our Northern Hemisphere folks, summer is starting to wind down already. For July, we saw a lot of new faces on the ONECommunity -- especially our most activ...

0 Comments

The Human Voice inside Automation

A colleague recently asked if I'd like to write about aspects of OneStream that I find interesting. As you can imagine, this took me a moment to think about, with all the different features and functi...

0 Comments

Plant a Tree in your Member List!

The CPM world has traditionally allowed users to define custom lists of members in code, which is very useful when built-in expansions are not enough for their needs. This is a fairly rare occurrence ...

1 Comments

Map Component Tutorial

So you’ve bought the OneStream Advanced Reporting and Dashboards book - congratulations on being on your way to mastering these tools! The book is chocked full of examples and guidance on how to tailo...

2 Comments

ONECommunity Highlights: June 2023

It's Our Sixth Month Anniversary! Can you believe it? We have been posting the monthly highlight for an entire half a year already! Have you made the list of our most active users? Or perhaps you've p...

0 Comments