Skip to main content

Variance Reporting - How to do it - Part I



Looking at the word Variance Reporting reminds us about the @VAR and @VARPER functions available in Essbase with which you can do variance reporting. One of my good friend wrote a blog post how to perform variance reporting Here.

I would not re-invent the wheel but rather would speak about what are the different ways of performing variance analysis. I would split this in to three parts and woudl cover the basics in Part I.

These days, Essbase applications are not used just for analysis and reporting. They are used even for Planning, Forecasting and Actuals for baseline. It so happens that you might have to do a lot of Variance Reporting and it is not just restricted to Act Vs Bud but rather a more complex and advanced way of variance reporting.

We have recently upgdraded our application from sys9 to EPM11 and we were given requirement to build pre-built reports using Hyperion Financial Reports which they are currently using in Excel and they are even doing Variance Analysis in Excel which might go wrong somewhere in reporting.

So, we have proposed that we would build Variance reporting scenarios that would help them to retrieve the data from essbase rather than performing variance analysis in Excel.

 So, The Next Questions that comes is, How many such Variance Scenarios would I need?

Well, it depends on what type of data you are loading (Actual, Plan & forecast). You can categorize the Variance Reporting as
  1. Variance Reporting across Time Periods
  2. Variance Reporting across Scenarios (Actual, Plan, Forecast)
It so happens that users might request to have [1] and [2] and Q-T-D and Y-T-D level also. So, make sure that your application can handle Q-T-D and Y-T-D Reporting.

Have a checklist prepared and write down how many Variance Reporting scenarios would you require and check with the users.
Be prepared for the worst as users might come back tomorrow and say that may be "If i have this variance reporting then it would be good. Can you do it?" 
Once you have all the elements in place, it doesn't take much time to build as per the reporting requirements. Requirements and Design are important
In the next post, I will talk about more on how many would you need and how to approach for building.

Comments

Post a Comment

Popular posts from this blog

EPM Cloud Tips & Tricks - #1

The first EPM cloud product was released in 2014 and it's been six years till date. I was recently part of an FCCS implementation project. I know what you might be thinking. Coming from completely essbase and planning background and been working on it for almost 12 years and doing an FCCS project? Well, it turned out that way and it was a change for me too than being in my comfort zone and took it as a challenge.  I have been very busy for over the past one year and I didn't really had a chance or time to get back to my blogging and sharing my knowledge. The project finally went live and I am going to share my bit of learnings. Some of it you might alread know The first tip is going to be an easy one and those who have worked in FDMEE / Data Management in the cloud, you might already know it. But, this is very important when it comes to FCCS as zeroes are valid from Balance Sheet standpoint Data Management by default doesn't load zeroes. Below is a excerpt from the document...

OAC - New Interface

At ODTUG Kscope18 , Oracle has revealed new features and groundbreaking updates that are going to come in the next release in OAC. Have you ever wondered what it's going to be I was so excited that I kicked-off the promotional offer and fired up my OAC instance. But, I was surprised and felt sad after looking at the instance that is in public cloud and the instance that is going to come in the next release. Not sure if I am missing anything here which will enable me to access the newer interface / newer instance The new interface looks sleek and looks a lot better than the previous interface. I am using the instance as parts of Hands-On lab at ODTUG Kscope18. Not sure till when this environment will be available. I will update this blog and make it more comparitive with what is available right now in public cloud New JET UI. I don't know if that is the right way to call it but that's what it says when you fire up the OAC instance new interface Less clutter and wa...

OAC - Switch Classic to Modern - Trick

Back to back posts today. But, I am excited and wanted to share this cool hack....Not sure if anyone has figured it out.... I did a blogpost on OAC new / modern interface and few features that I really liked. You can find my blogpost here . A good friend (became friends at Kscope18) Vijay Kurian  posted in his blog at theunlockedcube  about the Essbase Cloud features Part I and Part II and he has shown how to switch from classic interface to modern interface For some reason it didn't work for me in the pormotional OAC instance that I was using. However, I was able to switch based on what I poseted in my previous blogpost In general If you want to switch from Classic to Modern, follow the below screenshot However, for some reason that didn't work for me and I didn't knew why What I did might sound pretty silly but now I have the whole new Modern Interface that i can use without having to rely on the Deep Dive environment that I was using earlier. (That's Ora...