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.