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

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.