|
MOLAP essentially provides you an aggregate view of the data whereby you can
generate the analytics that you need. However, if you want to drill down to
the transaction level detail, it will not allow you to do so. For example, if
you are looking at the sales offices, which had less than 10% conversion of the
sales leads, and you want to drill down to the list of big-ticket leads, which
did not materialize, you will not be able to do so as MOLAP holds only aggregate
level of data.
At the same time, if you use HOLAP (a hybrid of MOLAP and ROLAP), it will provide
you that capability. Even ROLAP provides you the same capability, however its
method of internally managing the storage and processing is different.
|
