Microsoft KB Archive/296956

= Data Warehouse and Analysis Updates Included in Commerce Server 2000 Service Pack 1 (SP1) =

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 \sp1\backup\cs2ksp1_ _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  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:

 The script rebuilds the following reports:

'''&quot; Ad Placement

&quot; Campaign Event Summary

&quot; Usage Summary by Week of Year

&quot; Usage Summary by Day of Week

&quot; Usage Summary by Hour of Day

&quot; General Activity Statistics

&quot; Shopping Basket Events

&quot; 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.</li> 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.</li> The update program replicates the schema for the site analysis database into the cs2ksp1_<site_olapdbname>_schema_backup database.</li> 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.</li> The update program removes the following dimensions from the database and cubes:

&quot; [Campaign] dimension

&quot; [RegisteredUser] dimension

&quot; [CustomerOrders] dimension

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.</li></ol>

Additional query words: plutonium

Keywords: kbinfo KB296956

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.