SSAS Cube(olap's)

• miriyalasrihari

  Ten Centuries

  Points: 1225

  More actions

  January 1, 2011 at 6:37 am

  #144268

  hi,

  Wish You A Happy New Year...

  i have one doubt about Olap's

  which is better one among ROLAP, MOLAP, HOLAP?

  how to set the cube as ROLAP/MOLAP/HOLAP

  please suggest me some stuff.

  in my PC i have

  SQL Server 2008 (Enterprise Edition)

  SQL Server BIDS 2008(Visual Studio 9.0)

  [font="Verdana"]SRIHARI(:~[/font]

• amit_gupta01

  SSChasing Mays

  Points: 605

  More actions

  January 4, 2011 at 12:42 am

  #1268783

  By default, cube will be on MOLAP and

  In one line, this is the best approach if

  1) Your hardware supports the framework(CPU and m/y)

  2) you don't need real time data

  You can refer below article to understand it better:

  http://www.msbiconcepts.com/2010/09/analysis-services-storage-modes.html

  Thanks,
  Amit G
  http://www.msbiconcepts.com