Relationships Among Data Warehouse Cubes, Dimensions, Source Tables, and Reports

  • Article

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

Ee783687.note(en-US,CS.20).gifNote

  • Virtual cubes are listed in Bold type.
Cube Dimensions Source tables Reports Stored procedures
Bandwidth DateHour
Day of Week
Hour of Day
Site		 HitsByHour
  • Bandwidth Summary
  • Bandwidth Trends
  
Basket Events DateHour
Events
ProductCategory

Site
UserType

 csdw_BasketEventsFactView
  • Shopping Basket Events
  • Csdw_MakeProductCategoryInfo builds tables used to create the ProductCategory dimension.
  • Csdw_MakeBasketEventsFactTable regenerates the fact table view for the BasketEvents cube.
Buyer Visits BuyerVisits
Site
UserType		 UserBrowsingtoPurchaseFactView
  • Buyer Browse to Purchase
  
Entry Pages Date
Site
URI		 FirstUriByDate
  • Entry Pages
  • Csdw_MakeAggRequestsByURI builds tables used to create the URI dimension.
Exit Pages Date
Site
URI		 LastUriByDate
  • Exit Pages
  • Csdw_MakeAggRequestsByURI builds a table used to create the URI dimension.
mscsCampaign Advertiser
DateHour
Events
Page Group
Site
UserType		 mscsCampaignEvents

mscsOrderedImpressions
  • Ad Reach and Frequency by Date
  • Ad Reach and Frequency per Advertiser
  • Campaign Event Summary
  • Campaign Item Summary
  
mscsCampaignEvents Advertiser
DateHour
Events
Page Group
Site
User Type		 dbo.csdw_CampaignEventsFactView    
mscsDateIntersect Date
Hour of Day
Day of Week
Week of Year		 csdw_DateFactView  
  • Csdw_Datefill ensures that every hour between the minimum and maximum date in the csdw_DateFactView table has an entry in the Date table.
mscsOrderedImpressions Advertiser
Site		 dbo.csdw_OrderedImpressionsFactView    
mscsSales Address
Currency
Date
ProductCategory
Site
UserType		 dbo.csdw_SalesFactView
  • Product Sales
  • Csdw_MakeProductCategoryInfo builds tables 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		 dbo.csdw_VisitInfoFactView    
mscsWebUsage BrowserOS
BrowserType
Date
DateHour
Day of Week
Hour of Day
Referrer
Site
UserType
Week of Year		 mscsDateIntersect

mscsVisitInfo
  • Activity by Browser
  • Distinct Users By Time
  • General Activity Statistics
  • Top Referring Domains by Request
  • Usage Summary by Day of Week
  • Usage Summary by Hour of Day
  • Usage Summary by Week of Year
  • Usage Trends
  • User Trends
  • User Visit Trends
  
OrderEvents DateHour
Day of Week
Events
Hour of Day
Site
UserType
Week of Year		 Order
  • Order Events
  
Page Usage Date
HTTP Status
Is Request
Level Directory
Site
URI
Win32Status		 HitsInfo
  • Directories
  • Hits by HTTP Status
  • Hits by Win32 Status
  • Top Requested Pages
  • Csdw_MakeAggRequestsByURI builds a table used to create the URI dimension.

See Also

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

OLAP Cubes

Commerce Server 2002 Reports

Customizing Reports

Copyright © 2005 Microsoft Corporation.
All rights reserved.