Answer Posted / marcelo malheiros

I know a lot of people understand ROLAP and MOLAP as where
the information is stored: if data is in a RDBMS, is ROLAP;
if it is in a self-contained cube, it is MOLAP.

What I find the above a misconcept of the terms.

I believe ROLAP and MOLAP differs from each other in the
language you use to retrieve the result set and the result
set format...

I don't find that storage is relevant... How would classify
BI done on top of IMS, IDMS, ADABAS, VSAM and other non
RDBMS data storages?... Yes, BI started using those data
repositories... As well, how would you classify BI deployed
on top of a flat file or an XML file?...

SO MY POINT IS THAT THE DATA STORAGE DOES NOT DEFINE ROLAP
OR MOLAP...

By MOLAP:
I understand that the data is retrieved via MDX and the
result set is formated as a hiearchy with tags (something
similar to XML) which provides seemless hierarchy
manipulation capabilities to MOLAP.

By ROLAP:
I understand that the data is retrieved via SQL (relational
algebra) and the result set is always formatted as a table.

My humble 2 cents...

Cheers!
Marcelo

Explain the structure of cold fusion?

1022

---

Explain what is the difference between power center & power mart?

974

---

Explain what is cost benefit analysis (cba)?

959

---

What is pre-emptive and non-pre-emptive?

962

---

How to create diff. Types of templates?

1024

---

What is difference between query studio and report studio?

1073

---

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

932

---

Explain me what are conformed dimensions?

999

---

What is latest version of power center / power mart?

1034

---

Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

942

---

What is the extension of file to save template?

999

---

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2450

---

What is load manager?

1019

---

How to provide security in frame work manager for a query subject?

942

---

After the complete generation of a report who will test the report and who will analyze it?

970

---