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.