When we already have a data warehouse, why we need to create OLAP Cubes?
1. Quick Response -- Data already aggregated for performance
2. Easy navigation -- drill down, slice, dice
3.Easily use Excel to view data via Pivot Tables
4. Security: You can use the security setting to give end-users access to only those parts (slices) of the cube relevant to them
5. Store Hierachies
http://www.jamesserra.com/archive/2013/08/why-use-a-ssas-cube/
阅读(380) | 评论(0) | 转发(0) |