GeekInterview.com
Series: Subject: Topic:
Question: 37 of 46

What is Hyperion? Is it an OLAP tool? what is the difference between OLAP and ETL tools? What is the future for OLAP and ETL market for the next five years?

Asked by: kadilsai | Member Since Jan-2006 | Asked on: Jan 21st, 2006

View all questions by kadilsai

Showing Answers 1 - 4 of 4 Answers
Sunny

Answered On : Jan 29th, 2006

What is Hyperion? - Its an Business Intelligence tools. Like Brio which was an independent product bought over my Hyperion has converted this product name to Hyperion Intelligence.Is it an OLAP tool? - Yes. You can analyse data schemas using this tools.OLAP: Its an online analytical processing tool. There are various products available for data analysis.ETL: Extract , Transform and Load. This is a product to extract the data from multiple/single source transform the data and load it into a a table,flatfile or simply a target.There is a quite a bit compitation in the market with regard to the ETL product as well as the OLAP products. These tools would definately be widely used for data load and data analysis purpose. 

Yes  3 Users have rated as useful.
  
Login to rate this answer.
joys

Answered On : May 28th, 2006

There r only 2 ways available to get data from a datawarehouse or a database.one is using sql statement and other method is using an OLAP tool(ex:cognos, business objects.....)So Hyperion is an example for a OLAP tool. ETL is a process of Extracting data from a source systems(a system where client's transactional business information resides) and performing business logic(applying TRANSFORMATION rules) on the collected source information(business logic depends on business requirements), and LOADING the precise data into a warehouse(propably a relational database). OLAP comes into picture after ETL developers design the warehouse........by using olap tools a business user can generate standard reports(without having sql knowledge he can do this)

Yes  1 User has rated as useful.
  
Login to rate this answer.
Om Prakash Bang

Answered On : Sep 21st, 2006

Hyperion ia a Business Intelligence (BI) and Business Performanc Management (BPM ) Tool.  Its a market leader in Financial, Operational and Strategic Planning. It is having applications for Planning, consolidation, scorecarding, reporting, dashboards, Analysis, Workspace, Master Data Management and Foundation.ETL Tools is for Extracting source data, Transforming as required and Loading into DW. it is first part of DW. Now large fact and dimension tables are in DW. If you have to generate crosstab report from these tables, it will take very long time. So these DW tables are transformed into Cubes and stored in OLAP Server. Any Report Generation, Analysis is done on these... Cubes are having pre agreegated values and hence Report Generation will be much faster.

  
Login to rate this answer.
Andy

Answered On : Jul 18th, 2007

Hyperion has different modules such as essbase, interactive reporting, financial reporting and production reporting. Each tool has its own functionality. Hyprion interactive reporting and essbase are OLAP tools.

Yes  1 User has rated as useful.
  
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.