What is Molap and Rolap? What is Diff between Them?
Answer Posted / marcelo malheiros
Hello Pratap,
Sorry but you are missing the some steps re retrieving
information from a cube...
As you may know, a cube can have its data stored in a RDBMS
(in tables).
In order to retrieve the data from the RDBMS, when the
frontend sends a MDX instruction to the cube, the cube has
to translate the MDX instruction into SQL and send the SQL
to the RDBMS. The RDBMS returns a table as result set from
the SQL statement. The cube reads that table (result set)
and converts it to a hierarchical result set. The
hierarchical result set is then sent to the front-end that
formats the information and displays it to the end-user...
So, in the perspective of the frontend, an MDX instruction
is sent to the cube and a hierarchical result set is
received by the cube... Even if the data is in a RDBMS...
Sumarizing: Doesn't matter if the cube is self-contained or
if the information is stored elsewhere, for the frontend
the storage is transparent because a MOLAP frontend ALWAYS
sends a MDX instruction to the cube and receives a
hierarchical result set...
I hope that helps...
Cheers!
Marcelo
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the different types of fact tables used in data warehousing?
What is meant by metadata in context of a data warehouse?
Explain the definition of normalized and denormalized view?
What is Cognos script editor?
What is an er diagram?
What is difference macros and prompts?
Explain what are the advantages data mining over traditional approaches?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What are fact, dimension, and measure?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What are the different methods of loading dimension tables?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Explain what are the vaious etl tools in the market?
What is Discrete and Continuous data in Data mining world?
Can you brief about the Data warehouse project you worked on?