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

 

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

 

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.

In This Section

 

 

---

• Basic Structures of the Data Warehouse Analytics System Logical Schema
• What Are the Data Warehouse Logical Schema Relations?
• What Are the Data Warehouse OLAP Cubes?
• What is the OLE DB Provider for Commerce Server?
• Data Warehouse COM Objects
• Primary Data Warehouse Business Classes
• Data Warehouse Schema Reference
• What Data Does DTS Import into the Data Warehouse?
• Data Warehouse Relationship Tables
• Commerce Server DTS Tasks
• Data Warehouse Storage Engine

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.