Data Warehouse Week 9 - 45818

Solution Posted by
Vivekmanhas1

Vivekmanhas1

Rating : No Rating
Solution Detail
Price: $8.00
  • From: ,
  • Posted on: Sat 08 Mar, 2014
  • Request id: # 45740
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description
Solution Description


MOLAP (Multi-dimensional Online Analytical Processing):

When you select MOLAP storage mode and process partitions, it stores a copy of source data and aggregations in a multi-dimensional structure in analysis services server. You can expect a good query performance if you are using MOLAP storage mode because MOLAP structure is highly optimized to maximize query performance and queries fetch data from multidimensional structure instead of source data. Aggregations also help in maximizing query performance.

Advantages:
   1. Good query performance than ROLAP
   2. If your cube is processed then you can access cube data even if you don't have relationa

Attachments
compare.rtf
compare.rtf