Microsoft KB Archive/298530

= Sales Cube Processing Is Slow in Commerce Server 2000 Data Warehouse =

Article ID: 298530

Article Last Modified on 10/21/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q298530



SYMPTOMS
In a Commerce Server 2000 Data Warehouse, you may notice that processing of the Sales cube takes an excessive amount of time.



CAUSE
The Sales cube schema contains the BasketItemOrdersView view as its Fact table. The design of the BasketItemOrdersView contains an unnecessary join between the OrderFormLineItemsView view and the Products table using the ProductNameCat field.



RESOLUTION
To resolve this problem, obtain the latest service pack for Commerce Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

297216 INFO: How to Obtain the Latest Commerce Server 2000 Service Pack



STATUS
Microsoft has confirmed that this is a problem in Microsoft Commerce Server 2000. This problem was first corrected in Commerce Server 2000 Service Pack 1.

Additional query words: DW

Keywords: kbbug kbfix kbcommserv2000sp1fix KB298530

-

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

© Microsoft Corporation. All rights reserved.