全部博文(69)
发布时间:2016-10-08 10:36:39
When we already have a data warehouse, why we need to create OLAP Cubes?1. Quick Response -- Data already aggregated for performance2. Easy navigation -- drill down, slice, dice3.Easily use Excel to view data via Pivot Tables4. Security: You can use the security setting to give end-users .........【阅读全文】
发布时间:2016-10-07 01:08:59
There are several Operations in OLAP, which are : Roll-up, Drill-down, Slice or Dice and Pivot.Roll-up (Aggregation)dimension reduction, e.g. total sales by countrysummarization over aggregation hierarchy, e.g. total sales by city and year, totals sales by region and by yeaDrill-d.........【阅读全文】