cancel
Showing results for 
Search instead for 
Did you mean: 

Reasons - Planning on OLAP

former_member191765
Active Participant
0 Kudos

Experts,

Can you please let me know the reasons for most of the planning systems(BPC/IP/BPS/Hyperios) running on OLAP systems.?

Thank you.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Anjan,

There are several reason, list below are few of them

  1. Enable users to analyze multidimensional data interactively from multiple perspectives.
  2. Easy and fast retrieval of data.
  3. Easy to organize the data.
  4. Support for functions such as: roll-up (aggregation), drill-down and slicing and dicing.

Regards,

Kalyan.

former_member191765
Active Participant
0 Kudos

I know these Basic olap func.somehow I have not convinced with these.

They can do the same by data replication if they plan on non OLAP systems  and do the above funcs

Former Member
0 Kudos

Hi Anjan,

The general flow is that through replication you transform the data and move to a staging area and from where you move it to OLAP.

There are always options, replication is an option you can consider, but performance of data retrieval, query execution and ease of maintainence are factors that are better in OLAP systems than in non-OLAP system. The OLAP engine will have better performance when compared to replication in other datawarehouse.

Regards,

Kalyan.