ROLAP Vs MOLAP

Hi there:
Does anyone has any suggestions when building a ROLAP Cube? should I go with
ROLAP or go MOLAP with analysis Services? which one is better?
Thanks a lot.
--
JairoIt's usually better to go with MOLAP as it's much faster but will require
more disk space for storing the cube (fact and dimension data).
ROLAP will be slower as the user is basically executing SQL queries againt
the underlying relational database when slicing and dicing.
For more info read up in BOL or check this link
http://businessintelligence.ittoolb...-and-holap-2934
"Jportelas" <Jportelas@.discussions.microsoft.com> wrote in message
news:C1121799-7088-41F9-9EEB-5EBFD4AF2E70@.microsoft.com...
> Hi there:
> Does anyone has any suggestions when building a ROLAP Cube? should I go
> with
> ROLAP or go MOLAP with analysis Services? which one is better?
> Thanks a lot.
> --
> Jairo|||Refer to the following article, especially the section titled "Choose MOLAP
to Improve Query Responsiveness"
Microsoft SQL Server 2000 Analysis Services Performance Guide:
http://www.microsoft.com/technet/pr...n/ansvcspg.mspx
Generally speaking, MOLAP provides better responsiveness and performance
than ROLAP, except for real time partitions and perhaps very large ( > 2 GB)
sized partitions.
"Jportelas" <Jportelas@.discussions.microsoft.com> wrote in message
news:C1121799-7088-41F9-9EEB-5EBFD4AF2E70@.microsoft.com...
> Hi there:
> Does anyone has any suggestions when building a ROLAP Cube? should I go
> with
> ROLAP or go MOLAP with analysis Services? which one is better?
> Thanks a lot.
> --
> Jairo|||molap always.
a terrabyte database isn't big enough to use rolap. this i know.
maybe if you got a bigger data set, but i really really doubt it.