Interested to Buy Any Domain ? << Click Here >> for more details...
What is Molap and Rolap? What is Diff between Them?
- 10 Answers
- 20552 Views
- I also Faced
- E-Mail Answers
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
List down some of the real time data-warehousing tools?
Explain what are the mapping paramaters and maping variables?
Explain what are non-additive facts?
What are data validation strategies for data mart validation after loading process?
Explain what is the metadata extension?
What is data stream and data adaopter?
Can we take backup when the database is opened?
Can we start and stop single session in concurent bstch?
Explain vldb?
What is the difference between view materialized view and view?
What is recovering sessions?
What are the fundamental elements of the data warehouse?
Explain what is the difference between stop and abort?
Why is dimensional normalization not required?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
