[管理学]DM-Ch-02数据仓库与OLAP技术.pptVIP

* * * Roll down下卷 (Drill down下钻): 上卷的逆操作 从高层汇总到低层汇总或明细数据，或引入新的维度 drill-down on time from quarters to months Q1 Q2 Q3 Q4 Chicago New York Vancouver TV CD PC 710 820 402 471 605 TV CD PC New York Vancouver Chicago Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 102 150 150 典型的OLAP操作 Slice(切片) and dice(切块): 投影和选择 Q1 Q2 Q3 Q4 Chicago New York Vancouver TV CD PC 710 820 402 471 605 Dice for location=(“Chicago” or “New York” ) and (time=“Q1” or “Q2”) and ( item =“TV” or “CD”) Q1 Q2 Chicago New York 710 471 TV CD Slice