Microsoft KB Archive/298533

= Incorrect Join in Campaign's OLAP Cube =

Article ID: 298533

Article Last Modified on 10/21/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q298533



SYMPTOMS
In the Campaign's OLAP cube, the Campaign table is incorrectly joined to the Campaign Item Dimension View on the SiteName field. The tables should actually be joined on the CampaignId field. The result is a Cartesian join, which may cause the OLAP services to fail if the cube or dimension grows to a large size.



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.



MORE INFORMATION
Commerce Server 2000 Service Pack 1 removes the Campaign dimension. Therefore, this is not a problem in SP1; however, if you have reports that need the Campaign dimension, you must edit the dimension so that the join between the two tables is on the SiteName field.

Keywords: kbbug kbfix kbcommserv2000presp1fix kbcommserv2000sp1fix kbqfe KB298533

-

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

© Microsoft Corporation. All rights reserved.