The year is 2038; following the event known as The Global Souffle
Incident, on 15 July the entire world population woke up speaking
nothing but French. Mon dieu! OneStream gurus the world over were
sw...
Mapping can be complex. Here’s an example and a solution to minimize the
writing of business rules and use the out-of-the-box OneStream
functionality to maintain them.The data source provided is simpl...
Have you run into the situation where a customer has a KPI or
statistical account that they want OneStream to dynamically calculate
for one Scenario Type and users to enter for another? If you’ve work...
It's Friday afternoon, and you are already tasting a metaphorical
daiquiri. Suddenly, the phone rings: it's your boss! Are you getting a
pay rise? Did he finally agree to send you to Splash on expense...
Many of us have been through the rigors of data validation at some point
during a system implementation – and if you haven’t, lucky you. For the
unlucky ones, you’ve likely encountered someone on your...
The Problem BiBlend creates data tables named according to this
structure: BIB____
When building a DataAdapter that connects to such table, the first
instinct would be to use Substitution Variables, s...
Security is at the top of everyone’s minds these days. It should be -
sensitive financial data is well… sensitive. But at the same time,
administering security doesn’t need to be complex. Our customer...
1. Log Cleaner OneStream provides sophisticated and detailed audit trail
capabilities using various types of logging. The logging functionality
is distributed over the system and the Log Cleaner Marke...
How to setup Data Entry 123 Data Entry 123 requires the configuration of
database settings that are also required for many other MarketPlace
solutions. After downloading the solution as a .zip file fr...
So, where do you start with Parcel Services? We’ll first describe the
setup of the solution and after that the usage. How to setup Parcel
Services Parcel Services requires Ancillary Table access like ...
The most common issue with predictive systems is the quality of the
source data. Without proper data quality used for input, what can be
expected of the outcome? That’s exactly where OneStream disting...
First of all, please note that the solution Scenario Analysis 123 is not
intended for full Entity or multiple-hierarchy consolidations spanning
multiple periods or years. Therefore, it is mainly desig...
According to the official documentation, this solution is described as:
“The Task Manager (UTM) Solution is a way to organize workflows inside
and outside of OneStream. It provides one stop for Admini...
End User Training apps in the OneStream MarketPlace In the MarketPlace,
you’ll find a wide range of end user training material. There is
standard training material available for: End User Excel Analys...
When scrolling through the Market Place and working with the solutions,
there are actually a few that should be included in every application.
In my opinion, these are the 7 must haves: 1. Excel Add-I...
Of course, the Market Place is not the only place to train end users.
Outside of the MarketPlace, there are a number of ways to acquire
knowledge about OneStream as well: OneStream AcademyContains hun...
So, the answer is ‘yes’. If you want to know more, keep reading. First
start by making sure you back up your databases unless you are on the
cloud. This is important. The cost of not backing up your d...
The skill set needed to administrate an OneStream application is very
valuable. Luckly you should not need to look farther than the team you
have that supports the application. Not only the key resour...
To understand how OneStream performs many of its tasks and operations –
including logic execution, consolidation, and data cache – it is
critical to understand the concept of Data Units. A Data Unit r...
Custom calculation rules are powerful tools in data automation. One
simple way to make them even more powerful, is to create and capture an
audit trail of when these rules have been run by end users. ...
A simple way to ensure consistent cube view formats and save time is to
create style parameters at the beginning of your OneStream
implementation project. This will ensure that everyone involved in
de...
Originally Prepared by Peter Fugere The one part of any project that
involved volumes of data that can never be underestimated is the data
reconciliation. It will always take much longer than you plan...