MOLAP vs OLAP in terms of BI:
OLAP: Interactive Analysis of data on multiple dimensions. you can consolidate(aggreagate) ,drill down, slice and dice. Ex: all sales offices are rolled up to the sales department or sales division to anticipate sales trends.
OLAP is highly scalable, Time consuming* and provide attribute based analysis. we can implement level based hierarchies.
MOLAP: An alternate of OLAP. MOLAP differs significantly in that (in some software) it requires the pre-computation and storage of information in the cube.
MOLAP is fast, flexible, supports parent child and level based hierarchies by default.
For instance we have a analysis report on the same data, build on top of OLAP and on essbase cube. Essbase cube in some cases proven to be 300% faster than OLAP report.
OLAP: Interactive Analysis of data on multiple dimensions. you can consolidate(aggreagate) ,drill down, slice and dice. Ex: all sales offices are rolled up to the sales department or sales division to anticipate sales trends.
OLAP is highly scalable, Time consuming* and provide attribute based analysis. we can implement level based hierarchies.
MOLAP: An alternate of OLAP. MOLAP differs significantly in that (in some software) it requires the pre-computation and storage of information in the cube.
MOLAP is fast, flexible, supports parent child and level based hierarchies by default.
For instance we have a analysis report on the same data, build on top of OLAP and on essbase cube. Essbase cube in some cases proven to be 300% faster than OLAP report.
very interesting information thanks for given such a helpful info.its very useful to OBIEE learners.we also providing Obiee Online Training
ReplyDeleteSuch a very useful article. Very interesting to read this article. About the oracle fusion Online Training is one of the leading Online Training institute .
ReplyDeleteOracle fusion financials training
This is very informative and interesting for those who are interested in blogging field. Great blog and couldn’t be writing much better!
ReplyDeleteOracle Fusion HCM Technical Online Training
This post is very informative for everybody. I would like to appreciate your work for good accuracy and got informative knowledge from here. Nice effort, very informative, this will help me to complete my task. Thanks for share it keep it up.
ReplyDeleteOracle fusion Financials Training in hyderabad
Oracle Fusion Financials online Training in hyderabad