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

OLAP Cubes

Commerce Server 2002 Reports

Customizing Reports

Copyright © 2005 Microsoft Corporation.
All rights reserved.