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 transactions on your site. The number of transactions is a measure. The transaction and the products purchased are dimensions. The following figure shows the relationship between dimensions and 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 DTS 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 |
---|---|
mscsCampaign |
Advertiser DateHour Events Page Group Site UserType |
mscsCampaignEvents |
Advertiser DateHour Events Page Group Site UserType |
mscsOrderedImpressions |
Advertiser Site |
mscsSales |
Date ProductCategory Site UserType Address Currency |
Basket Events |
DateHour Events Site UserType Product Category |
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 |
Entry Pages |
Date Site URI |
Exit Pages |
Date Site URI |
mscsWebUsage |
Date DateHour Day of Week Hour by Day Referrer UserType Week of Year |
mscsVisitInfo |
Date DateHour Day of Week Hour by Day Referrer UserType Week of Year |
Page Usage |
Date HTTP Status Is Request Level Directory Site URI Win32Status |
For more information about OLAP cubes, see SQL Server Books Online.
See Also
Configuring the Default Web Site Properties for Import
Configuring the Web Server Log Import DTS Task
Adding a Non-Commerce Application to a Site
Copyright © 2005 Microsoft Corporation.
All rights reserved.