Custom Reports or Cubes Based on OLAP Objects Are Modified in Commerce Server 2000 SP1 (297137)


The information in this article applies to:

  • Microsoft Commerce Server 2000
This article was previously published under Q297137

SYMPTOMS

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

CAUSE

For performance and scale issues, several changes were made to the Commerce Server OLAP schema in Commerce Server 2000 SP1. 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.

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.
Modification Type:MajorLast Reviewed:10/18/2002
Keywords:kbprb KB297137
©2002 Microsoft Corporation. All rights reserved.