Interested to Buy Any Domain ? << Click Here >> for more details...
What is Molap and Rolap? What is Diff between Them?
- 10 Answers
- 20337 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
How can you set the session management?
How to limit the max no of rows retrieved in the report?
What is the difference between connected and unconnected stored procedures?
What is the limit to the number of sources and targets you can have in a mapping?
What are universe requirements?
I know of using applysimple, but there are other ways too?
What is meta data and system catalog?
Explain what is a three tier data warehouse?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Why should we use data ware housing and how can you extract data for analysis with example?
What is difference between e-r modeling and dimensional modeling?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain is olap databases are called decision support system true/false?
What are snapshots? What are materialized views & where do we use them?
What is batch processing?
