Microsoft KB Archive/297137

= Custom Reports or Cubes Based on OLAP Objects Are Modified in Commerce Server 2000 SP1 =

Article ID: 297137

Article Last Modified on 10/18/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



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.



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.

Additional query words: RegisteredUser CustomerOrders

Keywords: kbprb kbpending KB297137

-

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

© Microsoft Corporation. All rights reserved.