MOLAP< ROLAP< HOLAP

  • Hi, we have these 3 modes in ssas,

    can anybody explain simply when to use these 3 modes with the reason?

  • Simply Put:

    MOLAP must be used when query performance is important. Cubes data and aggregations are stored on SSAS server in this mode. But, data changes in the source doesn't automatically reflect in the cube unless it's processed frequently. Processing is the price.

    If source changes needs to be reflected instantly, then ROLAP is the way. Nothing is stored in the cube. When a user queryies the cube data is retrived from the source - this higly slows down query performance.

    HOLAP falls in the middle.

    See this link for more info.

    http://www.bidn.com/blogs/DustinRyan/ssis/872/ssas-2008-storage-modes

  • its clear, thank you sam.

    niha

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply