Dimensional Data Operation - Dice (or Dicing)

Data System Architecture

About

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 a single value for a cube.

Example

look for sales of a particular product on a particular day to a particular customer.





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