Conceptual question: MOLAP

View previous topic View next topic Go down

Conceptual question: MOLAP

Post  ratnalein on Mon Jun 18, 2012 9:00 pm

Hallo everyone,

I am using Oracle DB to build my datawarehouse. Untill now, I always use the ROLAP technique. Therefore, the star schema must be modelled before.

I have a question regarding MOLAP technique:
If I want to use MOLAP technique(saving the data in multidimensional structure from the beginnig), do I need to model the star schema first? Does MOLAP need star schema actually? If not, how can I modell my datawarehouse logically, so that I can choose the attribute I want to be showed in the reporting, just like in the case of ROLAP?

Thank you for your comments.

Regards,
Ratna

ratnalein

Posts : 1
Join date : 2012-06-18

View user profile

Back to top Go down

Re: Conceptual question: MOLAP

Post  John Simon on Tue Jun 19, 2012 8:22 pm

You are always better off building a dimensional model. MOLAP is great, but not always suited to all reporting requirements.
Besides which, every OLAP tool I know works better on a dimensional model.

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

View user profile http://jsimonbi.wordpress.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum