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