Relationships among Data Warehouse Cubes, Dimensions, Source Tables, and Stored Procedures

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

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	Stored procedures
Bandwidth	DateHour Day of Week Hour of Day Site	HitsByHour	None.
Basket Events	DateHour Events ProductCategory Site UserType	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 Visits	BuyerVisits Site UserType	UserBrowsingtoPurchaseFactView	None.
Entry Pages	Date Site URI	FirstUriByDate	Csdw_MakeAggRequestsByURI builds tables that are used to create the URI dimension.
Exit Pages	Date Site URI	LastUriByDate	Csdw_MakeAggRequestsByURI builds a table that is used to create the URI dimension.
mscsCampaign	Advertiser DateHour Events Page Group Site UserType	mscsCampaignEvents mscsOrderedImpressions	None.
mscsCampaignEvents	Advertiser DateHour Events Page Group Site User Type	csdw_CampaignEventsFactView	None.
mscsDateIntersect	Date Hour of Day Day of Week Week of Year	csdw_DateFactView	Csdw_Datefill makes sure that every hour between the minimum and maximum date in the csdw_DateFactView table has an entry in the Date table.
mscsOrderedImpressions	Advertiser Site	csdw_OrderedImpressionsFactView	None.
mscsSales	Address Currency Date ProductCategory Site UserType	csdw_SalesFactView	Csdw_MakeProductCategoryInfo builds tables that are 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	csdw_VisitInfoFactView	None.
mscsWebUsage	BrowserOS BrowserType Date DateHour Day of Week Hour of Day Referrer Site UserType Week of Year	mscsDateIntersect mscsVisitInfo	None.
OrderEvents	Date Hour Day of Week Events Hour of Day Site UserType Week of Year	Order	None.
Page Usage	Date HTTP Status Is Request Level Directory Site URI Win32Status	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