Data Warehouse and Analysis Updates Included in Commerce Server 2000 Service Pack 2 (311496)

MORE INFORMATION

1. Commerce Server Service Pack 2 opens the <COMMERCE_SERVER_ROOT>\sp2\backup\cs2ksp2_<sitename>_upgrade.log log file.
2. The update program connects to the Microsoft SQL Server Data Warehouse and checks for the existence and version of the csdw_analysis_version view. If the view exists, the site has already been updated to SP1 and the update process only applies to updates that are unique to SP2. If the version in the view indicates SP2, the update is ended.
3. The update program runs the Cs2ksp1.sql (if SP1 has not been applied) and Cs2ksp2.sql script files from the <COMMERCE_SERVER_ROOT> directory and applies the script to the SQL Server Data Warehouse. The script file then backs up the contents of the CubeProcInfo and Report tables to the csdw_spbk_CubeProcInfo and csdw_spbk_Report tables, respectively.
4. The script rebuilds the following objects, and saves the old versions as follows:

   Object	Saved Object	Last Changed
   CSDW_MakeViewBasketEventFact	CSDW_spbk_MakeViewBasketEventFact	SP1
   CSDW_MakeViewNewUsersByDate	CSDW_spbk_MakeViewNewUsersByDate	SP1
   CSDW_MakeAggRequestsByURI	CSDW_sp2bk_MakeAggRequestsByURI	SP2
   CSDW_MakeViewCampaignResultsByDay	CSDW_sp2bk_MakeViewCampaignResultsByDay	SP2
   CSDW_MakeUserAgentData	CSDW_sp2bk_MakeUserAgentData	SP2

   
   
   
5. The script adds the CSDW_DateFill object.
6. The script rebuilds the following reports:

   Report	Last Changed
   Ad Placement	SP1
   Campaign Event Summary	SP1
   Usage Summary by Week of Year	SP1
   Usage Summary by Day of Week	SP1
   Usage Summary by Hour of Day	SP1
   General Activity Statistics	SP1
   Shopping Basket Events	SP1
   Product Sales	SP1
   User Trends - Static	SP2
   User Days to Register - Static	SP2
   Usage Trends - Static	SP2
   Usage Summary by Day of Week	SP2
   Usage Summary by Hour of Day	SP2
   Usage Summary by Week of Year	SP2

   
   
7. The script deletes the following reports:

   Report	Deleted during
   Customer Spend Summary report	SP1
   User Trends - Dynamic	SP2
   User Days to Register - Dynamic	SP2
   Usage Trends - Dynamic	SP2

   
   NOTE: The Usage Trends, User Days to Register, and Usage Trends reports are static reports after installation of Service Pack 2.
   
   
8. The update program identifies the location of the Microsoft Analysis Services (OLAP) database that is associated with this site.
9. The update program verifies whether the cs2ksp1_<site_olapdbname>_schema_backup OLAP database exists on the Analysis server. If the database exists, the database has already been updated, and the update process is ended.
10. The update program replicates the schema for the site analysis database into the cs2ksp1_<site_olapdbname>_schema_backup database.
11. The update program removes several dimensions from the OLAP database, provided that they are not used by a non-Commerce Server object. For example, if you have added dimensions to custom cubes, those dimensions are removed.
12. The update program removes the following dimensions from the database and cubes:

    " [Campaign] dimension
    " [RegisteredUser] dimension
    " [CustomerOrders] dimension

13. The update program adds the DateWithHour dimension.
14. The update program removes the following members:

    Member(s)	Cube
    Users	Users
    All calculated measures except Avg Requests and Avg Duration	Web Usage

    
    
15. The update program adds the following cubes:
    • mscsDateIntersect
    • mscsVisit
    
    
16. The update program add the DateWithHour dimension to the Web Usage cube.
    
    NOTE: You can examine the results of the updated tasks in the log file. If an error message occurs during the update process, it is written to the Cs2ksp2.log log file.