Data Warehouse Cube and Table Usage by Report

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

The following table shows which cubes, tables, and stored procedures are used to create the different reports.

Report

Cube

Source tables

Stored procedures

Bandwidth Summary

Bandwidth Trends

Bandwidth

HitsByHour

None.

Shopping Basket Events

Basket Events

csdw_BasketEventsFactView

Csdw_MakeProductCategoryInfo builds tables that are used to create the ProductCategory dimension.

Csdw_MakeBasketEventsFactTable regenerates the fact table view for the BasketEvents cube.

Buyer Browse to Purchase

Buyer Visits

UserBrowsingtoPurchaseFactView

None.

Entry Pages

Entry Pages

FirstUriByDate

Csdw_MakeAggRequestsByURI builds tables that are used to create the URI dimension.

Exit Pages

Exit Pages

LastUriByDate

Csdw_MakeAggRequestsByURI builds a table that is used to create the URI dimension.

Ad Reach and Frequency by Date

Ad Reach and Frequency by Advertiser

Campaign Event Summary

Campaign Item Summary

mscsCampaign

mscsCampaignEvents

mscsOrderedImpressions

None.

Product Sales

None

RelativeDate

DateDimensionView

Site

csdw_SalesFactView

None.

Customer Sales

None

OrderGroup

RegisteredUser

Site

RelativeDate

DateDimensionView

None.

Query Strings Single Value

None

RelativeDate

DateDimensionView

SVQueryStringFactTable

Site

None.

Query Strings Multi Value

None

RelativeDate

DateDimensionView

MVQueryStringFactTable

Site

None.

New Registered Users

Registered User Properties

Registered Users by Date Registered

User Registration Rate

None

Site

RelativeDate

DateDimensionView

RegisteredUser

LinkSiteRegisteredUserRel

None.

User Days to Register

None

UserRegistrationFactView

Site

RelativeDate

DateDimensionView

None.

Activity by Browser

Distinct Users by Time

General Activity Statistics

Top Referring Domains by Request

Usage Summary by Day of Week

Usage Summary by Week of Year

Usage Trends

User Trends

User Visit Trends

mscsWebUsage

mscsDateIntersect

mscsVisitInfo

None.

Entry Path Analysis

None

RelativeDate

DateDimensionView

Site

None.

Order Events

OrderEvents

Order

None.

Directories

Hits by HTTP Status

Hits by Win32 Status

Top Requested Pages

Page Usage

HitsInfo

Csdw_MakeAggRequestsByURI builds a table that is used to create the URI dimension.

See Also

Other Resources

Data Warehouse Analytics Business Scenarios

Data Warehouse Relationship Tables