OLAP Objects Modified in Commerce 2000 SP2 (310895)


The information in this article applies to:

  • Microsoft Commerce Server 2002
  • Microsoft Commerce Server 2000 SP1
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.

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:10/9/2003
Keywords:kbpending kbprb KB310895
©2003 Microsoft Corporation. All rights reserved.