Microsoft KB Archive/310895

= OLAP Objects Modified in Commerce 2000 SP2 =

Article ID: 310895

Article Last Modified on 10/29/2007

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Service Pack 1

-



This article was previously published under Q310895



SYMPTOMS
Custom reports or cubes that are based on OLAP objects that were modified in Commerce Server 2000 Service Pack 2 (SP2) may fail or behave unexpectedly.



CAUSE
For accuracy, performance, and scale issues, several changes were made to the Commerce Server OLAP schema in Commerce Server 2000 SP2. This may cause problems in custom reports that rely on deleted or changed objects.



OLAP Changes

 * Removed [Campaign] shared dimension.
 * Removed [Campaign] dimension from the [Campaign] cube.
 * Removed [RegisteredUser] shared dimension.
 * Removed [RegisteredUser] dimension from [Basket Events] cube.
 * Removed [RegisteredUser] dimension from [Web Usage] cube.
 * Removed [Customer Orders] shared dimension.
 * Removed [Customer Orders] dimension from [Sales] cube.
 * Removed [Weekly User Trends] cube. User Trends - Static report has an example of how to correctly calculate this.
 * Removed all calculated members from [Web Usage] cube. Use [mscsVisit] cube.
 * Removed Users measure from [Users] cube. Usage Trends - Static report has an example of how to correctly calculate this.

Report Changes

 * Ad Placement: Use Advertiser dimension instead of Campaign.
 * Campaign Event Summary: Use Advertiser dimension instead of Campaign.
 * Usage Summary by Week of Year: Removed RegisteredUser dimension. No change obvious to user.
 * Usage Summary by Day of Week: Removed RegisteredUser dimension. No change obvious to user.
 * Usage Summary by Hour of Day: Removed RegisteredUser dimension. No change obvious to user.
 * General Activity Statistics: Removed RegisteredUser dimension. No change obvious to user.
 * Shopping Basket Events: Removed RegisteredUser dimension. No change obvious to user.
 * Product Sales: Removed Customer Orders dimension. No change obvious to user.
 * Customer Spend Summary: Removed this report.
 * User Trends: Use User Trends - Static.
 * Usage Trends: Use Usage Trends - Static.
 * Usage Summary by Day of Week: Updated to use members from mscsVisit.
 * Usage Summary by Hour of Day: Updated to use members from mscsVisit.
 * Usage Summary by Week of Year: Updated to use members from mscsVisit.

Keywords: kbproductlink kbpending kbprb KB310895

-

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

© Microsoft Corporation. All rights reserved.