Is Essbase for me?...Where do I start learning Essbase?

Is essbase for me to study? Is essbase hot in the market? Does essbase has future? I am from XYZ background, I want to learn Essbase, Is it for me? …..

I have been encountering these questions now and then. Essbase is an OLAP tool. I have seen many who hardly have understood OLAP as a concept (at least, the definition of it) but are working on Essbase.

I would fit a guy ideal to work on essbase as someone who has a technical computer science background, had worked on one of the relational databases (it might be oracle, SQL server, DB2 ...or any), warehouse conceptual clarity, and the location of OLAP in the architecture of its design, who know the industry which he works, and understands the importance of conversion of data into information. Last but most important, who is willing to agree that Business and IT go hand-in-hand, and IT is the enabler.

These are few traits, if one already has, can enter into the world of essbase with ease. There are other aspirants, who don’t have technical, complementing background, and had never worked on any database but are impressed by the OLAP technology and willing to contribute to the world of it ,and they are interested to start with this tool. For few ,it might be an obligation ,as their job demands them to work on this tool. For them, who are about to start and stand at the cross roads, and confused with the multitude of ways available to start learning this tool .I have some information.

First, realize the objective of an OLAP and how big, the role, it plays in the Decision science of any company. Understand the importance of data warehouse, and why does one need OLAP and where does it fit in. Technically, what skills are required as a pre-requisite to learn essbase. Answer to these, concepts of any database, minimal programming understanding...if you are sure of them, kick off.

Finally, before I conclude I have a request to all, when they start reading the material of essbase of any OLAP tool for that matter you need to imagine two important things
1. Imagine how exactly the essbase technically works Ex: When some one loads data into a cube, he has to imagine as a yellow content filled in that cubes Ex2: If FIX statement is written in a script, then he needs to imagine a cube , with only the fixed content is taking part in the operation or transaction
2. Try to co-relate every technical change with the requirement of the user. Always imagine a user sitting in front of your report made by your OLAP logic trying to make a sense and decision based on it. This decision made based on your report will eventually change the face of his company.

Any question/enquiry, mail me

Have you heard of Buzz word 'Analytics', How is Hyperion Essbase related to 'Analytics'

As the Definition of 'Analytics' goes, its the data analysis ,modelling ..bla bla ...for ex: developing of banks customer profile , identifying hte profitable customer.
These days, we hear of BA ,its Business analytics, its other way of saying Business data analysis.
Now , coming to our very own essbase, this is the BI tool,which aids the business to analyse data with help of its quick information output in the form of dashboard...etc for you.
Hence, Essbase is not all of Analytics, but it complements the Analytics a lot.

MOLAP, ROLAP, Hybrid ...Where does Hyperion Essbase fit in?

One knows the old ways of defining OLAP i.e FASMI - Fast Analysis of Shared Multidimensional Information.

Let me introduce essbase in the context of FASMI
Essbase is Fast,as it gives results i.e information on the reporting platform quickly .Ideally, not more than few seconds .

Essbase is used for analysis purpose , Essbase is very much capable to embeding the business logic .It does encourage programming and is very flexible in changing the calculations i.e business logic .Hence, freedom to change logic as per the requirement of Business.thats why you see financial institues or any industry ,where they have huge data availability, they buy essbase and use it to provide analyses for the Business decisions .

Essbase does encourage multiple users( shared Users) to access at a time in a very secured mode.Essbase does update the changes and serve the users in a timely fashion.

Essbase is multidimensional in nature , if you see any application/ database , it has numerous dimensions ( sbjective to the requirement of the Business), mutiple hierarchies .Mutlidimensionality is most important part of definition.i shall talk on Multidimensionality again as an individual topic.

Information, what do we do after making all the essbase smart cubes , we do communicate through our reporting tool/platform to extract information .This defines information.

Note: Dont get confused with MOLAP and OLAP, most of them use it interchangingly.
Thus, Essbase is MOLAP or an OLAP

Sandeep Reddy Enti

Welcome

Hi ,
Welcome to all .