Tuesday, May 17, 2011

What are dimensions, mesaures, and cubes ?


www2.cs.uh.edu/~ceick/DM/dm_cubes.ppt
 
 
nA data warehouse is based on a multidimensional data model which views data in the form of a data cube
nA data cube, such as sales, allows data to be modeled and viewed in multiple dimensions
nDimension tables, such as item (item_name, brand, type), or time(day, week, month, quarter, year)
nFact table contains measures (such as dollars_sold) and keys to each of the related dimension tables
 
 

What Are the Data Warehouse Analytics Components?

Commerce Server 2007
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
This section describes components of the Data Warehouse Analytics System.


http://msdn.microsoft.com/en-us/library/bb219339(v=cs.70).aspx

What Are the Data Warehouse OLAP Cubes?

Commerce Server 2007
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
Online analytical processing (OLAP) cubes are data structures that the Data Warehouse uses to contain the data that you import. The cubes divide the data into subsets that are defined by dimensions.
A dimension is the descriptive attribute of a measure. For example, a dimension might describe the number of transactions on your site. The number of transactions is a measure. The transaction and the products purchased are dimensions. The following illustration shows the relationship between cubes, dimensions and measures.


Bb219339.csmn_DWA_OlapCubess(en-US,CS.70).gif 

No comments:

Post a Comment