Dimensional Data Operation - Slice (Or Slicing)

Data System Architecture

About

A slice is selecting a subset of a multi-dimensional array. This is equivalent to a filter operation..

Slicing involves using a member of one dimension to provide a slice of the cube.

Example

You could slice a cube by using a particular product and view all sales of that product across all dates and customers.





Discover More
Star Schema
Dimensional Data Modeling - Dimension (Perspective)

A dimension is a part of a dimensional schema and provide the basis for analyzing data through slicing and dicing A dimension is just a set of descriptif attribute that are generally grouped: in a...
Star Schema
Dimensional Data Modeling - Grain

The grain is the combination of all lower hierarchy level of the descriptif attribute of a relation (table or query). If you query only a table, the unique key of this table is the grain If you query...
Data System Architecture
Dimensional Data Operation - Dice (or Dicing)

Dice is a dimensional data operation that performs a slice on more than two dimensions of a data cube (or more than two consecutive slices). Dicing involves providing values for every dimension to locate...
Data System Architecture
Dimensional Data Operations (OLAP Operation)

This sections is all cube operations. The analyst can navigate through the database and screen for a particular subset of the data, changing the data's orientations and defining analytical calculationsSlicDicDrill...



Share this page:
Follow us:
Task Runner