Relationships among Data Warehouse Cubes, Dimensions, Source Tables, and Stored Procedures

The following table lists the Data Warehouse cubes and associated dimensions, the source table for the cube, and the reports that use the cube.

Note

Virtual cubes are listed in Bold type.

Cube

Dimensions

Source tables

Stored procedures

Bandwidth

  • DateHour

  • Day of Week

  • Hour of Day

  • Site

HitsByHour

 None.

Basket Events

  • DateHour

  • Events

  • ProductCategory

  • Site

  • UserType

csdw_BasketEventsFactView

  • Csdw_MakeProductCategoryInfo builds tables that are used to create the ProductCategory dimension.

  • Csdw_MakeBasketEventsFactTable regenerates the fact table view for the BasketEvents cube.

Buyer Visits

  • BuyerVisits

  • Site

  • UserType

UserBrowsingtoPurchaseFactView

 None.

Entry Pages

  • Date

  • Site

  • URI

FirstUriByDate

  • Csdw_MakeAggRequestsByURI builds tables that are used to create the URI dimension.

Exit Pages

  • Date

  • Site

  • URI

LastUriByDate

  • Csdw_MakeAggRequestsByURI builds a table that is used to create the URI dimension.

mscsCampaign

  • Advertiser

  • DateHour

  • Events

  • Page Group

  • Site

  • UserType

mscsCampaignEvents

mscsOrderedImpressions

 None.

mscsCampaignEvents

  • Advertiser

  • DateHour

  • Events

  • Page Group

  • Site

  • User Type

csdw_CampaignEventsFactView

 None.

mscsDateIntersect

  • Date

  • Hour of Day

  • Day of Week

  • Week of Year

csdw_DateFactView

  • Csdw_Datefill makes sure that every hour between the minimum and maximum date in the csdw_DateFactView table has an entry in the Date table.

mscsOrderedImpressions

  • Advertiser

  • Site

csdw_OrderedImpressionsFactView

 None.

mscsSales

  • Address

  • Currency

  • Date

  • ProductCategory

  • Site

  • UserType

csdw_SalesFactView

  • Csdw_MakeProductCategoryInfo builds tables that are used to create the ProductCategory dimension.

  • Csdw_MakeSalesFactTable regenerates the fact table view for the Sales cube.

mscsVisitInfo

  • BrowserOS

  • BrowserType

  • Date

  • DateHour

  • Day of Week

  • Hour of Day

  • Referrer

  • Site

  • UserType

  • Week of Year

csdw_VisitInfoFactView

 None.

mscsWebUsage

  • BrowserOS

  • BrowserType

  • Date

  • DateHour

  • Day of Week

  • Hour of Day

  • Referrer

  • Site

  • UserType

  • Week of Year

mscsDateIntersect

mscsVisitInfo

 None.

OrderEvents

  • Date

  • Hour

  • Day of Week

  • Events

  • Hour of Day

  • Site

  • UserType

  • Week of Year

Order

 None.

Page Usage

  • Date

  • HTTP Status

  • Is Request

  • Level Directory Site

  • URI Win32Status

HitsInfo

  • Csdw_MakeAggRequestsByURI builds a table that is used to create the URI dimension.

See Also

Other Resources

Data Warehouse Analytics Business Scenarios

Data Warehouse Relationship Tables

  • Last updated on