Dimensional Data Operation - Slice (Or Slicing)

Data System Architecture

Dimensional Data Operation - Slice (Or Slicing)

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 - 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...



Share this page:
Follow us:
Task Runner