Share via


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.

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

Adding a Non-Commerce Application and Web Server


All rights reserved.