OLAP Operations
Slice
Slice
Slice is the process of retrieving data from a cube by filtering on one dimension. An example of a slicing operation would be extracting the sales figures of the communication devices for only the Asian region.
Dice
The dice operation produces a subcube by allowing the business user to filter data based on multiple dimensions. This example shows a dicing operation, where the quarterly sales figures for the cell phone category across all brands is extracted for the Asian region. Here, the data has been filtered based on the Product and Location dimensions.
Roll Up
Allows the user to navigate among levels of data to the most summarized. For example, given the total city-wise sales figures for different states such as California, Florida, and New York, the user can view the aggregated sales figures per state.
Drill-down
Allows the user to navigate among levels of data ranging to the most detailed. This example drills down into sales figures for Nokia in Florida, U.S for Q4 in 2011, then for the month of December, and finally Christmas Eve.
Pivot
Allows users to view data from different perspectives. For example, in the first image, products are arranged vertically and locations horizontally while viewing data for a particular quarter. Pivoting allows users to replace locations with time periods to see data across time for a single product.
Slice
Dice
Roll Up
Drill Down
Pivot
Slice
Slice is the process of retrieving data from a cube by filtering on one dimension. An example of a slicing operation would be extracting the sales figures of the communication devices for only the Asian region.
Dice
The dice operation produces a subcube by allowing the business user to filter data based on multiple dimensions. This example shows a dicing operation, where the quarterly sales figures for the cell phone category across all brands is extracted for the Asian region. Here, the data has been filtered based on the Product and Location dimensions.
Roll Up
Allows the user to navigate among levels of data to the most summarized. For example, given the total city-wise sales figures for different states such as California, Florida, and New York, the user can view the aggregated sales figures per state.
Drill-down
Allows the user to navigate among levels of data ranging to the most detailed. This example drills down into sales figures for Nokia in Florida, U.S for Q4 in 2011, then for the month of December, and finally Christmas Eve.
Pivot
Allows users to view data from different perspectives. For example, in the first image, products are arranged vertically and locations horizontally while viewing data for a particular quarter. Pivoting allows users to replace locations with time periods to see data across time for a single product.
No comments:
Post a Comment