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 <COMMERCE_SERVER_ROOT>\sp2\backup\cs2ksp2_<sitename>_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 <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 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
- The script adds the CSDW_DateFill object.
- 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
- 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.
- The update program identifies the location of the Microsoft Analysis Services (OLAP) database that is associated with this site.
- 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.
- 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:
" [Campaign] dimension
" [RegisteredUser] dimension
" [CustomerOrders] dimension - The update program adds the DateWithHour dimension.
- The update program removes the following members:
Member(s) Cube Users Users All calculated measures except
Avg Requests and Avg Duration
Web Usage
- The update program adds the following cubes:
- mscsDateIntersect
- mscsVisit
- 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.
Additional query words: plutonium
Keywords: kbproductlink kbinfo KB311496