Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is Multi Dimension OLAP CUBE and give example cube with more than 3 dimensions

Tags:

As I am new to SSAS, have been reading an article on Multi-Dimension OLAP Cube and struggling to understand Cube concepts, It has been said that Although the term "cube" suggests three dimensions, a cube can have up to 64 dimensions. Could you please explain how is this possible on cube (other than 3-Dim example x,y,z planes)? Please don't give only links to study but also expecting some explanation.

like image 948
rmdussa Avatar asked Nov 24 '09 04:11

rmdussa


People also ask

What is a multi dimensional cube?

A cube is a multidimensional structure that contains information for analytical purposes; the main constituents of a cube are dimensions and measures. Dimensions define the structure of the cube that you use to slice and dice over, and measures provide aggregated numerical values of interest to the end user.

What is OLAP cube example?

An OLAP Cube is a data structure that allows fast analysis of data according to the multiple Dimensions that define a business problem. A multidimensional cube for reporting sales might be, for example, composed of 7 Dimensions: Salesperson, Sales Amount, Region, Product, Region, Month, Year.

How many dimensions are in an OLAP cube?

The OLAP cube usually has three dimensions, but it can be constructed of an infinite number of dimensions (called MOLAP - multidimensional OLAP cube). Each dimension is saved into its dimension tables.

What are the three dimensions of data cube?

Data cube can be 2D, 3D or n-dimensional in structure. Data cube represent data in terms of dimensions and facts. Dimension in a data cube represents attributes in the data set. Each cell of a data cube has aggregated data.


2 Answers

In the DW world, the word "dimension" is overloaded -- changes meaning depending on context. Here is an example.

  • On a certain date, a customer walks into a store and buys a product.

This example has four dimensions (date, customer, store, product) and one fact (sales). So a typical Kimball star would look like:

dim4_model_01

A dimension (table) is a look-up table for properties of objects that rarely change. Product, customer and store may change some of their properties (attributes), but they rarely do. Fact table captures interactions between these objects. At the intersection of dimensions date, store, product and customer lies a measure SalesAmount. Note how easy is to aggregate (sum) the sales amount by date, by year, by product, by brand, by city, by country, by age group, by whatever -- which was the idea in the first place.

like image 162
Damir Sudarevic Avatar answered Sep 21 '22 19:09

Damir Sudarevic


Don't think of a cube as a three-dimensional structure (despite the name). A "dimension" in a data warehouse situation is simply a varying value that you can use to access data in your warehouse. You could think of them as key parts but ones that can be accessed individually, or in combination, quite easily (unlike primary keys in a classical table).

As for an example, you may have the following dimensions in a warehouse for keeping customer and sales data.

  • Customer ID.
  • State (location).
  • Year.
  • Month.
  • Day of month.

That layout (a five-dimensional "super-hyper-cube") would allow queries to be easily performed for customers that cross state boundaries and that may have different purchasing patterns throughout the year (and even at different times of the month).

All of those key-parts would just point to a single sales figure for the day of month in a specific month in a specific year in a specific location for a specific customer.

An example on how to access that data. Let's say you wanted to see how all customer's buying patterns changed on a monthly basis, averaged over all the years. You would do this to see which customers generated the most revenue for you at specific times of the year so you could, for example, target your advertising at them in the month or so before then.

You would use the customer ID and month to extract information, effectively "collapsing" the state, year and day-of-month dimensions (in other words, sum up the sales figures for those three dimensions to get a two-dimensional result, customers vs. month).

like image 42
paxdiablo Avatar answered Sep 21 '22 19:09

paxdiablo