Blog
February 25, 2021
The Fall and Rise of Performance Management
Those who have been around long enough might remember that back in the end of the 80s, beginning 90s, the usual way of keeping track of your accounting was to keep the different processes like A/R, A/P, G/L, inventories, and billing in different solutions which are often poorly integrated. It took a long time to reconcile the numbers between the G/L and the sub-ledgers...
Managing Director, Sweden
Max Persson
January 15, 2021
How to better manage dimensions in OneStream with Bulk Deletions
Dimensions form the framework on which the reporting structure is built. OneStream Cube Dimensions are created based upon the reporting requirements for a client. Dimensions are assigned to cubes and are the framework that define a subsection...
Business Analyst
Sarika Patil
![90511 [Converted]-01.jpg](https://static.wixstatic.com/media/8d912b_7ce96802702647f7b98472050a2decbd~mv2.jpg/v1/fill/w_278,h_185,al_c,q_80,usm_0.66_1.00_0.01/90511%20%5BConverted%5D-01.jpg)
October 28, 2020
Spreadsheet Hell:
The Consolidation, Close and Reporting Conundrum -
Part 2
Consolidation today is no longer the aggregation of financials of two or more companies in the group. For many organizations, consolidation...
Managing Director, APAC
Darshana Sanghavi
October 9, 2020
Extensible Dimensionality – The Secret Sauce For A Unified CPM Approach
Typically, organizations have a planning solution and a consolidation solution. There are two separate applications for each of these business use cases. The...
Managing Director, APAC
Darshana Sanghavi
August 7, 2020
Hail, the Power of the Trident!
Previously, we took a closer look on how risk assessment and risk management can be of focus through the balance sheet integrity approach. To successfully achieve this, the different finance teams must be able to share relevant data with...
Managing Director, APAC
Darshana Sanghavi
February 19, 2021
Using Existing Excel Files to Load Data in OneStream
Most businesses use Excel to work on their Planning, Budgeting, Forecasting and Reporting needs. The source data for these statements is an output of another system like an ERP. It is usually in the form of flat files or Excel files.
In a OneStream implementation, we can use many of the existing...
Business Analyst
Shrushti Patil
December 11, 2020
Derivative Rules - A Step Towards Data Quality
In OneStream, all active dimensions require transformation rules. These are used to ensure that the data goes in the required combinations in the OneStream Solution.
Transformation rules (one to one, composite, range, list & mask)...
Business Analyst
Shreyas Deshmukh
October 23, 2020
Spreadsheet Hell:
The Consolidation, Close and Reporting Conundrum -
Part 1
The financial consolidation, close and reporting process is one that most organizations continue to struggle with. Is it because the process is...
Managing Director, APAC
Darshana Sanghavi
September 25, 2020
Data Quality --> Confidence
CFOs have moved on from reporting about the past to predicting and paving the way into the future.
The C-suite often knows what is happening in the organization but at times struggles to understand why.
For this, they must be armed with...
Principal Consultant
Niki Dedhia
July 10, 2020
Finance Leaders Can Manage Risks Through a Balance Sheet Focus
The challenges that many businesses are facing currently are varied, with the majority seeing an impact on the revenue streams. Strong leadership from the CFO is the need of the hour.
Managing Director, APAC
Darshana Sanghavi
February 4, 2021
Multi Columnar Data Load
in OneStream
For any EPM / CPM project, some of the key discussions revolves around “How do we use Excel files to load data into the application?”’. “Can we make it easier for users to enter data in the system?”. The data load using Excel may either be a single column of amounts or having amounts in multiple columns. Some examples of having multiple column loads are...
Business Analyst
Zeeshan Ali
November 06, 2020
Power-Excel with OneStream
Let’s be honest; finance likes to work with Excel and come what may, we can take a person out of Excel but not Excel out of a person. It is that intertwined in the life of a finance person.
How about using a CPM platform that lets you work with Excel while...
Principal Consultant
Niki Dedhia
October 22, 2020
The Need for a Common Language in Performance Management
After many years in the corporate world, in various roles as a Group Controller, Software Implementations, and advisory, I must say that very little has changed since I started my...
Managing Director, Sweden
Max Persson
August 14, 2020
Truly Single Platform
To achieve the close coupling of information between the GL, Consolidation, and the Planning, Budgeting and Forecast teams, it’s important to have all of them work on the same platform. There are quite a few EPM / CPM vendors or products...
Managing Director, APAC
Darshana Sanghavi