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. |