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

The following table lists the Commerce Server 2009 dimensions and the source tables for each dimension.

Dimensions	Source table	Stored procedure
Address	Address	None.
Advertiser	Campaign CampaignItemDimensionView Customer	None.
BrowserOS	UserAgentOperatingSystem	None.
BrowserType	UserAgent UserAgentBrowserCategory UserAgentVersion	Csdw_MakeUserAgentData updates the UserAgent table with information about known browsers.
BuyerType	csdw_BuyerTypeDimensionView	None.
Currency	CurrencyCode	None.
Date	DateDimensionView	Csdw_Datefill makes sure that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table.
DateHour	DateDimensionView	Csdw_Datefill makes sure that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table.
Day of Week	DateDimensionView	Csdw_Datefill makes sure that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table.
Events	EventsDimensionView	None.
Hour of Day	DateDimensionView	Csdw_Datefill makes sure that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table.
Http Status	HttpStatus	None.
Level Directory	LevelDir Level1Dir Level2Dir Level3Dir Level4Dir Level5Dir Level6Dir URI	None.
Page Group	PageGroupDimensionView	None.
Is Request	IsRequestDimensionView	None.
ProductCategory	csdw_CategoryTree	Csdw_MakeProductCategoryInfo builds tables that are used to create ProductCategory dimension.
Referrer	ReferrerDomain	None.
Site	SiteDimensionView	None.
Uri	RequestsByUri	Csdw_MakeAggRequestsByURI builds a table that is used to create the URI dimension.
UserType	csdw_UserTypeDimensionView	None.
Week of Year	DateDimensionView	Csdw_Datefill makes sure that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table.
Win32Status	Win32Status	None.

See Also

Other Resources

Data Warehouse Analytics Business Scenarios

Data Warehouse Relationship Tables