Question:
What's the meaning of those acronyms, and what are the differences ?
Answer:
ROLAP: relational OLAP stores aggregation in a relational structure and leaves the partitions source data in its existing relational strucure
MOLAP: multidimentional OLAP store aggregation and a copy of the partitions source data in a multidimentional structure on a server
_________________
life only sucks when you let it get that way!
Answer:
wilde1, following to your explanation,
can I consider that rolap is more ODS stuff
and molap is cubes ?
Answer:
You dont have aggregates on ODS.....
MOLAP will only run on MS SQL 2000 it offers improved reporting performance for quiries due to the fact it can utilize the multidimnesional features of sql
Both run from Cubes
_________________
life only sucks when you let it get that way!
Answer:
wilde1, following to your explanation,
can I consider that rolap is more ODS stuff
and molap is cubes ?
ROLAP is the relational implementation of a multidimensional model (ex. the classic Star Schema, or the Snowflake) , in the case of BW, ROLAP is the set of tables of the BW Extended Star Schema (Fact, Dimension,SID's,etc).
ODS are kind of flat tables , with semantic keys as a common table.
Andrea