Skip to main content

Posts

Showing posts with the label Planning

Quick Tips on data recast and data validation

I was working on a data recast process which involves applying some complex mappings to the source data before it can be loaded to the target cube. This is quite a common exercise in applications related to Essbase, Planning and HFM. I used a database to hold all those mappings along with the source data. I would recommend this approach as you have full control on what mapping you are applying and you can keep track of what mapping changes you are doing since the data recast process is a repeatable process After the mappings have been applied, I had to do some manual addition of few accounts subtract data from few accounts. I am not an expert in SQL so excel pivot table to the rescue. All good and the data is ready to be loaded to the cube Tip #1: Standardization is the key Always use a standard load rule and a standard data load format for the data file (sort the columns from least to most and the dense dimension at the last and for columns). Also, use a standard delimiter...

Variance Reporting - How to do it - Part III

In the Last series of Posts Here (Part I) and Here (Part II), we have talked about the basics of Variance Reporting (Part I) and Variance Reporting Across Time Periods (Part II).  In this post, we will talk about variance reporting Across Scenarios (Actual, Plan, Forecast). Most of the Organizations who have been using Oracle EPM set of tools as part of their financial process would have the below process setup Fetch the Actuals (transaction level data) from different source systems for their reporting & analysis. Most of the actual data comes from oracle GL, Oracle EBS, PeopleSoft or any type of an OLTP system or it could even come from flatfiles or excel or could be any readable format Have a Planning application where users can input their PLAN data. Most of the organizations have long-term goals and target and plan to achieve it. What are the steps that are involved to achieve their goals and targets is part of their planning. I am not going to talk in de...

My Essbase Blog

It's good to start blogging after many years but this time it's all about technical. This is my first blog on Oracle EPM. I have been working on Essbase, Planning, HFR, DRM and ODI (All tools part of Oracle EPM Product Suite) from quite a long time and I still feel that I am a beginnler. Oracle EPM (Enterprise Performance Management) is a set of analytical process and business tools that allow a business to track, measure and achieve goals. The core components of Oracle EPM are Hyperion Financial Management, Oracle Hyperion Planning and powerful analytical tool Essbase. Oracle EPM has undergone lot of changes from it's inception (from v11.1.1.1) to current version (v11.1.2.3) and new tools were added. EPM Stack is bundled with Performance Managenemt Applications and with powerful analytics to align financial close, planning, reporting, analysis, and modeling and unlock business potential. There has also been lot of integration between ERP Systems to EPM applicatio...