Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Conceptual question: MOLAP

2 posters

Go down

Conceptual question: MOLAP Empty Conceptual question: MOLAP

Post  ratnalein 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

Back to top Go down

Conceptual question: MOLAP Empty Re: Conceptual question: MOLAP

Post  John Simon 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

http://jsimonbi.wordpress.com

Back to top Go down

Back to top

- Similar topics

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