Hyperion HFM/ Hyperion Planning both are Essbase based. They are front-end tech andEss-base is the BACK end. Ess-base is a M-OLAP. There are THREE types of OLAP TECHNOLOGY PRESENT in the market. These are ROLAP, MOLAP and HOLAP.

An EXAMPLE of ROLAP is BO. Here we deal with table and they acts as a virtual cube. But if we think about Oracle Express Hyperion Essbase and Cognos then they are real cubes. Thus MOLAP. ROLAP+MOLAP=HOLAP.

In case of BO, we need to join to attain the OLAP effect virtually but behind is a joined table. But in Case of MOLAP there is no concept of table it is cube only.

For example a page is a table then a Book is a Cube.

Hyperion HFM/ Hyperion Planning both are Essbase based. They are front-end tech andEss-base is the back end. Ess-base is a M-OLAP. There are three types of OLAP technology present in the market. These are ROLAP, MOLAP and HOLAP.

An example of ROLAP is BO. Here we deal with table and they acts as a virtual cube. But if we think about Oracle Express Hyperion Essbase and Cognos then they are real cubes. Thus MOLAP. ROLAP+MOLAP=HOLAP.

In case of BO, we need to join to attain the OLAP effect virtually but behind is a joined table. But in Case of MOLAP there is no concept of table it is cube only.

For example a page is a table then a Book is a Cube.