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