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...
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...
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’...
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...
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 ...
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...
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...
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. ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Pumpkin Spice Latte Season! As Autumn and pumpkin spice sweep across
North America, we find ourselves entering the month of gratitude – which
is the perfect time to look back on how far the OneCommuni...
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...
Why You Should Care About Event Handlers? So, you're in the OneStream
universe, and you might be thinking, "What's the big deal about Event
Handlers?" Well, hold onto your hats because these aren't ju...
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...
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, ...
"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...
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...
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 ...
If you're currently grappling with consolidation performance issues or
encountering slow-rendering Cube Views, fear not. We've got you covered
with valuable insights on assessing your application and ...
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...