Microsoft KB Archive/812458

= FIX: Drillthrough Does Not Work for Some Dynamic Reports =

Article ID: 812458

Article Last Modified on 8/18/2003

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition

-



SYMPTOMS
When you enable drillthrough (as it is described in the Microsoft Commerce Server 2002 Help topic &quot;Enabling Drillthrough in Dynamic Reports&quot;), 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:  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 = &quot;DRILLTHROUGH\n&quot;; sMDX = sMDX + &quot;SELECT FROM [&quot; + element.DataMember + &quot;]\n&quot;; sMDX = sMDX + &quot;WHERE (&quot; + GetTupleMDX(tupCore);   Change this code to the following code block:   sMDX =  &quot;DRILLTHROUGH\n&quot;;    if (element.DataMember.charAt(0) == &quot;[&quot;)        sMDX = sMDX + &quot;SELECT FROM &quot; + element.DataMember + &quot;\n&quot;;    else        sMDX = sMDX + &quot;SELECT FROM [&quot; + element.DataMember + &quot;]\n&quot;;    sMDX = sMDX + &quot;WHERE (&quot; + 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.

Keywords: kberrmsg kbbug kbfix kbcommserv2002sp1fix KB812458

-

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

© Microsoft Corporation. All rights reserved.