Article ID: 296956
Article Last Modified on 10/18/2002
APPLIES TO
- Microsoft Commerce Server 2000 Standard Edition
This article was previously published under Q296956
SUMMARY
This article describes the updates that occur in the Data Warehouse and Analysis components when you apply Commerce Server 2000 Service Pack 1 (SP1).
For additional information about how to obtain the latest Commerce Server 2000 service pack, click the article number below to view the article in the Microsoft Knowledge Base:
297216 How to Obtain the Latest Commerce Server 2000 Service Pack
MORE INFORMATION
Commerce Server 2000 SP1 automatically updates the Data Warehouse and Analysis components of Commerce Server.
The Analysis update program performs the following steps:
- Commerce Server Service Pack 1 opens the log file <COMMERCE_SERVER_ROOT>\sp1\backup\cs2ksp1_<sitename>_upgrade.log.
- The update program connects to the SQL Server Data Warehouse and checks for the existence of the csdw_analysis_version view. If the view exists, the site has already been updated and the update process is terminated.
- The update program runs the Cs2ksp1.sql script file 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.
- The script rebuilds the following objects, and saves the old versions as follows:
Object Saved Object csdw_MakeViewBasketEventFact csdw_spbk_MakeViewBasketEventFact csdw_MakeViewNewUsersByDate csdw_spbk_MakeViewNewUsersByDate csdw_MakeAggRequestsByURI csdw_spbk_MakeAggRequestsByURI
- The script rebuilds the following reports:
" Ad Placement
" Campaign Event Summary
" Usage Summary by Week of Year
" Usage Summary by Day of Week
" Usage Summary by Hour of Day
" General Activity Statistics
" Shopping Basket Events
" Product Sales - The script deletes the Customer Spend Summary report. The update program then identifies the location of the Microsoft Analysis Services (OLAP) database that is associated with this site.
- The update program verifies if the OLAP database cs2ksp1_<site_olapdbname>_schema_backup exists on the Analysis server. If the database exists, the database has already been updated, and the update process is terminated.
- The update program replicates the schema for the site analysis database into the cs2ksp1_<site_olapdbname>_schema_backup database.
- 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.
- The update program removes the following dimensions from the database and cubes:
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 Cs2ksp1.log log file.
" [Campaign] dimension
" [RegisteredUser] dimension
" [CustomerOrders] dimension
Additional query words: plutonium
Keywords: kbinfo KB296956
