Relationships Among Data Warehouse Cubes, Dimensions, Source Tables, and Reports

The following table lists the Commerce Server Data Warehouse cubes and associated dimensions, the source table for the cube, and the reports that use the cube.

Note

• Virtual cubes are listed in Bold type.

Cube	Dimensions	Source tables	Reports	Stored procedures
Bandwidth	DateHour Day of Week Hour of Day Site	HitsByHour	Bandwidth Summary Bandwidth Trends
Basket Events	DateHour Events ProductCategory Site UserType	csdw_BasketEventsFactView	Shopping Basket Events	Csdw_MakeProductCategoryInfo builds tables used to create the ProductCategory dimension. Csdw_MakeBasketEventsFactTable regenerates the fact table view for the BasketEvents cube.
Buyer Visits	BuyerVisits Site UserType	UserBrowsingtoPurchaseFactView	Buyer Browse to Purchase
Entry Pages	Date Site URI	FirstUriByDate	Entry Pages	Csdw_MakeAggRequestsByURI builds tables used to create the URI dimension.
Exit Pages	Date Site URI	LastUriByDate	Exit Pages	Csdw_MakeAggRequestsByURI builds a table used to create the URI dimension.
mscsCampaign	Advertiser DateHour Events Page Group Site UserType	mscsCampaignEvents mscsOrderedImpressions	Ad Reach and Frequency by Date Ad Reach and Frequency per Advertiser Campaign Event Summary Campaign Item Summary
mscsCampaignEvents	Advertiser DateHour Events Page Group Site User Type	dbo.csdw_CampaignEventsFactView
mscsDateIntersect	Date Hour of Day Day of Week Week of Year	csdw_DateFactView		Csdw_Datefill ensures that every hour between the minimum and maximum date in the csdw_DateFactView table has an entry in the Date table.
mscsOrderedImpressions	Advertiser Site	dbo.csdw_OrderedImpressionsFactView
mscsSales	Address Currency Date ProductCategory Site UserType	dbo.csdw_SalesFactView	Product Sales	Csdw_MakeProductCategoryInfo builds tables used to create the ProductCategory dimension. Csdw_MakeSalesFactTable regenerates the fact table view for the Sales cube.
mscsVisitInfo	BrowserOS BrowserType Date DateHour Day of Week Hour of Day Referrer Site UserType Week of Year	dbo.csdw_VisitInfoFactView
mscsWebUsage	BrowserOS BrowserType Date DateHour Day of Week Hour of Day Referrer Site UserType Week of Year	mscsDateIntersect mscsVisitInfo	Activity by Browser Distinct Users By Time General Activity Statistics Top Referring Domains by Request Usage Summary by Day of Week Usage Summary by Hour of Day Usage Summary by Week of Year Usage Trends User Trends User Visit Trends
OrderEvents	DateHour Day of Week Events Hour of Day Site UserType Week of Year	Order	Order Events
Page Usage	Date HTTP Status Is Request Level Directory Site URI Win32Status	HitsInfo	Directories Hits by HTTP Status Hits by Win32 Status Top Requested Pages	Csdw_MakeAggRequestsByURI builds a table used to create the URI dimension.

See Also

Relationships Among Dimensions, Source Tables, and Stored Procedures in the Data Warehouse

OLAP Cubes

Commerce Server 2002 Reports

Customizing Reports

Copyright © 2005 Microsoft Corporation.
All rights reserved.