FIX: Drillthrough Does Not Work for Some Dynamic Reports (812458)


The information in this article applies to:

  • Microsoft Commerce Server 2002

SYMPTOMS

When you enable drillthrough (as it is described in the Microsoft Commerce Server 2002 Help topic "Enabling Drillthrough in Dynamic Reports"), it still does not work for some reports. You receive the following error message:
Could not get detail records for this aggregate. Make sure that permissions to obtain drillthrough records are set properly on the OLAP server.

WORKAROUND

To resolve this problem, change the Drillthrough.htc file. To do this, follow these steps:
  1. Locate Analysis\Drillthrough.htc. This file is located in the folder that contains your Business Desk Web site.
  2. Locate Function BuildDrillthroughSets.
  3. Locate the following code block in BuildDrillthroughSets (in Line 938):
    		sMDX = 	"DRILLTHROUGH\n";
		sMDX = sMDX + "SELECT FROM [" + element.DataMember + "]\n";
		sMDX = sMDX + "WHERE (" + GetTupleMDX(tupCore);
  4. Change this code to the following code block:
    	sMDX = 	"DRILLTHROUGH\n";
	if (element.DataMember.charAt(0) == "[")
		sMDX = sMDX + "SELECT FROM " + element.DataMember + "\n";
	else
		sMDX = sMDX + "SELECT FROM [" + element.DataMember + "]\n";
	sMDX = sMDX + "WHERE (" + GetTupleMDX(tupCore);

RESOLUTION

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

328814 INF: How to Obtain the Latest Commerce Server 2002 Service Pack

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:8/18/2003
Keywords:kberrmsg kbCommServ2002SP1fix kbBug kbfix KB812458 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.