Relationships among Dimensions, Source Tables, and Stored Procedures in the Data Warehouse
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The following table lists the Commerce Server dimensions and the source tables for each dimension.
Dimensions |
Source table |
Stored procedure |
|---|---|---|
Address |
Address |
None. |
Advertiser |
|
None. |
BrowserOS |
UserAgentOperatingSystem |
None. |
BrowserType |
|
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 |
|
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. |