Interested to Buy Any Domain ? << Click Here >> for more details...
What is Molap and Rolap? What is Diff between Them?
- 10 Answers
- 19935 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
Explain how to export mappings to the production environment?
Explain ddl (data definition language)?
What is the difference between ods and oltp?
What is a source qualifier?
Compare and contrast aggregates & indexes
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is the main difference between star and snowflake star schema? Which one is better and why?
What are the fundamental elements of the data warehouse?
What is a core dimension?
What is type 2 version dimension?
I know of using applysimple, but there are other ways too?
What is latest version of power center / power mart?
What are the differences between datamart vs. Reporting cube?
What is many-to-many dimensional model in datawarehousing ?
Can a dimension table contain numeric values?
