Microsoft KB Archive/311496

= Data Warehouse and Analysis Updates Included in Commerce Server 2000 Service Pack 2 =

Article ID: 311496

Article Last Modified on 10/29/2007

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q311496



SUMMARY
This article describes the updates that occur in the Data Warehouse and Analysis components when you apply Commerce Server 2000 Service Pack 2 (SP2).

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 SP2 automatically updates the Data Warehouse and Analysis components of Commerce Server.

The Analysis update program performs the following steps:  Commerce Server Service Pack 2 opens the \sp2\backup\cs2ksp2_ _upgrade.log log file. 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. The update program runs the Cs2ksp1.sql (if SP1 has not been applied) and Cs2ksp2.sql script files 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 adds the CSDW_DateFill object. The script rebuilds the following reports:

</li> The script deletes the following reports:

NOTE: The Usage Trends, User Days to Register, and Usage Trends reports are static reports after installation of Service Pack 2.

</li> The update program identifies the location of the Microsoft Analysis Services (OLAP) database that is associated with this site.</li> 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.</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

</li> The update program adds the DateWithHour dimension.</li> The update program removes the following members:

</li> The update program adds the following cubes: <ul> mscsDateIntersect</li> mscsVisit</li></ul>

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

Additional query words: plutonium

Keywords: kbproductlink kbinfo KB311496

-

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

© Microsoft Corporation. All rights reserved.