商业智能（BI）基础

引用链接:slice and dice

slice and dice

To slice and dice is to break a body of information down into smaller parts or to examine it from different viewpoints so that you can understand it better. In cooking, you can slice a vegetable or other food or you can dice it (which means to break it down into small cubes). One approach to dicing is to first slice and then cut the slices up into dices. In data analysis, the term generally implies a systematic reduction of a body of data into smaller parts or views that will yield more information. The term is also used to mean the presentation of information in a variety of different and useful ways.

This term can be compared to drilldown , which is the process of dividing an information area up into finer and finer layers in a hierarchy, but with the purpose of narrowing in to one small area or item.

引用链接：MDX Language Reference (MDX)

Multidimensional Expressions (MDX) Reference

引用链接：Drill Down/Up

(v) In information technology, to move from summary information to detailed data by focusing in on something. To drill down through a series of folders, for example, on a desktop means to go through the hierarchy of folders to find a specific file or to click through drop-down menus in a GUI. To drill down through a database is to access information by starting with a general category and moving through the hierarchy of field to file to record.

(n) Spelled drilldown. The act of focusing in. For example, "He got the information he needed through a drilldown of the database."

引用链接：Drill Through

(v.) Drill through is a term used to describe the act of exploring or browsing items like folders, files or related components. Generally associated with drill down and drill up, which indicate vertical movements between components, drill through is an action in which you move horizontally between two items via a related link. An example to drill through is in the case of two reports that are in a master /detail relation with each other, and by clicking a master item on the master report you reach the details of the clicked item on the details report.