OLAP basic multidimensional analysis operations

OLAPThe basic multidimensional analysis operations include drilling (drill-up and drill-down), slice, dice, and rotation.

Drilling:Is to change the level of the dimension and the granularity of the analysis. It includes drill-down and drill-up/roll-up ). Drill-up summarizes low-level detailed data to high-level summary data in one dimension, or reduces the dimension. drill-down is the opposite, it goes from summarized data to detailed data to observe or add new dimensions.

Slice and slice:After you select a value for a certain dimension, you are concerned about the distribution of measurement data on the remaining dimension. If there are only two remaining dimensions, the slice is used. If there are three or more dimensions, the slice is used.

Rotation:Is to change the direction of the dimension, that is, to reschedule the placement of the dimension in the table (such as row and column Interchange ).