GeekInterview.com
Series: Subject: Topic:
Question: 5 of 6

Hyperion HFM

Hi this is peter,recently i got trained in Hyperion Financial Management , can any body answer to my question, what is olap and whether it is related to HYPERION FINANCIAL MANAGEMENT.
Asked by: peter mathews | Member Since Jul-2008 | Asked on: Jul 18th, 2008

View all questions by peter mathews

Showing Answers 1 - 4 of 4 Answers

OLAP is an Online Analytical Processing means "it is a set of specification which allows the client application in retrieving the data from data warehouse.
It is not related to the HFM, because HFM is an functional to the hyperion tool.

If it is wrong send the right answer.

  
Login to rate this answer.
skkar79

Answered On : Apr 6th, 2009

View all answers by skkar79

Hyperion HFM/ Hyperion Planning both are based on Essbase. So Hyperion HFM and Planning are front-end tech. Essbase is the back end. Essbase is a M-OLAP. There is 3 type of OLAP technology there is the market. ROLAP, MOLAP, HOLAP.

BO is the typical example of ROLAP, here you deal with table and they will act as a virtual cube here. But if you think about Oracle Express, Hyperion Essbase and Cognos then they are real cubes not the virtual table act as a cube in case of BO. that is why they are MOLAP. ROLAP+MOLAP=HOLAP.

In case of BO you need to join to get the OLAP effect virtually but the behaind is a joined table. BUT in Case of MOLAP the concept of table is not there it is cube only.
I will give you a simple example like a page is a table then a Book is a Cube.

But is the data is huge then if is advisable to go for ROLAP not MOLAP. beacsse the performance is of the cube's will degrade. The Data should be arround 100 GB to 150 GB then it is ok to go with MOLAP if the that is more then that then you choose BO.

So probably its clear to you now.


  
Login to rate this answer.
cpmexpert

Answered On : Dec 16th, 2009

View all answers by cpmexpert

HFM has no OLAP in it.  It is built entirely on Relational technology.  Hyperion Planning is build on essbase OLAP and uses it's calculation engine for business logic.  Oracle/Hyperion will drive purchases so that Essbase is purchased with HFM along with reporting tools and seats.  Typical uses of OLAP will be to push data out of HFM to OLAP as a cross tab enabled datamart for reporting.  

  
Login to rate this answer.
mujeeb mohammed

Answered On : May 10th, 2013

Hi Peter if you are HFM trained person,dont think about OLAP its a pure technical it is useful to Essbase guys.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.