FIX: Drillthrough Does Not Work for Some Dynamic Reports

View products that this article applies to.

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.

Back to the top

WORKAROUND

To resolve this problem, change the Drillthrough.htc file. To do this, follow these steps:

Locate Analysis\Drillthrough.htc. This file is located in the folder that contains your Business Desk Web site.
Locate Function BuildDrillthroughSets.

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);

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);

Back to the top

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 (http://support.microsoft.com/kb/328814/ ) INF: How to Obtain the Latest Commerce Server 2002 Service Pack

Back to the top