Interested to Buy Any Domain ? << Click Here >> for more details...
What is Molap and Rolap? What is Diff between Them?
- 10 Answers
- 20233 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
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
I know of using applysimple, but there are other ways too?
What are components of report studio?
What are the data types present in bo? What happens if we implement view in the designer n report?
Why should we use data ware housing and how can you extract data for analysis with example?
What are session timeout and application timeout?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is the limit to the number of sources and targets you can have in a mapping?
What are aggregate transformation?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What are universe requirements?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
How are the dimension tables designed?
What is is a star schema?
What is the function of etl when used in data warehousing?
