Relationships Among Dimensions, Source Tables, and Stored Procedures in the Data Warehouse
The following table lists the Commerce Server dimensions and the source tables for each dimension.
Dimensions | Source table | Stored procedure |
---|---|---|
Address | dbo.Address | |
Advertiser | Campaign CampaignItemDimensionView Customer |
|
BrowserOS | UserAgentOperatingSystem | |
BrowserType | dbo.UserAgent dbo.UserAgentBrowserCategory dbo.UserAgentVersion |
Csdw_MakeUserAgentData updates the dbo.UserAgent table with information about known browsers. |
BuyerType | csdw_BuyerTypeDimensionView | |
Currency | dbo.CurrencyCode | |
Date | DateDimensionView | Csdw_Datefill ensures that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table. |
DateHour | DateDimensionView | Csdw_Datefill ensures 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 ensures that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table. |
Events | EventsDimensionView | |
Hour of Day | DateDimensionView | Csdw_Datefill ensures that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table. |
Http Status | HttpStatus | |
Level Directory | dbo.LevelDir Level1Dir Level2Dir Level3Dir Level4Dir Level5Dir Level6Dir URI |
|
Page Group | PageGroupDimensionView | |
Is Request | IsRequestDimensionView | |
ProductCategory | dbo.csdw_CategoryTree | Csdw_MakeProductCategoryInfo builds tables used to create ProductCategory dimension |
Referrer | ReferrerDomain | |
Site | SiteDimensionView | |
Uri | RequestsByUri | Csdw_MakeAggRequestsByURI builds a table used to create the URI dimension. |
UserType | dbo.csdw_UserTypeDimensionView | |
Week of Year | DateDimensionView | Csdw_Datefill ensures that every hour between the minimum and maximum date in the DateDimensionView table has an entry in the Date table. |
Win32Status | Win32Status |
See Also
Relationships Among Data Warehouse Cubes, Dimensions, Source Tables, and Reports
Copyright © 2005 Microsoft Corporation.
All rights reserved.