January 16, 2012 at 6:27 am
Hi, we have these 3 modes in ssas,
can anybody explain simply when to use these 3 modes with the reason?
January 17, 2012 at 5:07 am
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
Sam Vanga
http://SamuelVanga.com
January 17, 2012 at 5:28 am
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