OLAP Cubes
Online analytical processing (OLAP) cubes are data structures that the Data Warehouse uses to contain the data you import. The cubes divide the data into subsets, defined by shared dimensions.
A dimension is the descriptive attribute of a measure. For example, a dimension might describe the number of purchases a user makes. The number of purchases is a measure. The user and the products purchased are dimensions. The following figure shows the relationship between dimensions and measures. For more information about OLAP cubes, see SQL Server Books Online.
.gif "Dimensions and measures")
Units
Time
Product
Time
Product
Dimension
Tables
Geographic
Geographic
Dimension
Measures
The OLAP cubes used by Commerce Server are created during the unpacking process and are populated and processed for data retrieval when the Report preparation task is run. Storing data in cubes increases the speed of data retrieval when you run Web site analysis reports in Business Desk. The following table lists the Commerce Server cubes and dimensions.
| Cube | Dimensions |
| Weekly User Trends | Date Site Week of Year |
| Campaign | Advertiser Campaign DateHour Events Page Group Site UserType URI |
| Sales | CustomerOrders Date Products Site UserType |
| Basket Events | DateHour Events Products RegisteredUser Site UserType |
| OrderEvents | DateHour Day of Week Events Hour of Day Site UserType Week of Year |
| Buyer Visits | BuyerType Site UserType |
| Bandwidth | DateHour Day of Week Hour of Day Site |
| Users | Date Site UserType |
| Entry Pages | Date Site URI |
| Exit Pages | Date Site URI |
| Web Usage | Date DateHour Day of Week Hour by Day Referrer RegisteredUser SiteUserType Week of Year |
| Page Usage | Date HTTP Status Is Request Level Directory Site URI Win32Status |
See Also
Configuring Web Log Files for Import
Configuring Web Log File Import Properties