Which OLAP operation is used to extract a smaller subset of data from a…

Concept

OLAP navigation operations reshape a multidimensional data cube in distinct ways:

• Slice fixes ONE dimension to a single value to obtain a lower-dimensional sub-cube.

• Dice selects a range of values across SEVERAL dimensions at once.

• Roll-up / Drill-up aggregate measures to a coarser level of a hierarchy.

• Drill-down / Drill-through move toward finer detail or the underlying source records.

• Pivot (rotate) reorients the axes to view the same data from a new perspective.

Application

The question asks for the operation that pulls out a smaller subset by selecting specific dimension values. Holding one dimension at a chosen value (for example, fixing Time = Q1) collapses the cube along that axis and returns the flat sub-cube of all remaining dimensions at that value. That selecting-and-reducing behaviour is the Slice operation.

Cross-check

Among the offered operations, only Slice both selects on a dimension value and reduces the result to a smaller sub-cube. Roll-up and Drill-up only change the aggregation level, Drill-through fetches underlying detail, and Pivot only rotates the view, so none of them produce the described subset. Hence the answer is Slice.