Microsoft KB Archive/934096

= All the columns are displayed if you do not define any dimensions or any return columns when you create a drillthrough action in SQL Server 2005 Analysis Services =

Article ID: 934096

Article Last Modified on 5/18/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services
 * ProClarity Desktop Professional 6.1
 * ProClarity Web Professional 6.1
 * ProClarity Desktop Professional 6.2
 * ProClarity Web Professional 6.2
 * Microsoft ProClarity Desktop Professional 6.3

-



SYMPTOMS
Consider the following scenario. You create a drillthrough action in Microsoft SQL Server 2005 Analysis Services. You do not define any dimensions or any return columns.

In this scenario, all the columns are displayed for the measure group that is defined in the drillthrough action in the following programs:
 * Microsoft ProClarity Desktop Professional 6.3 and earlier versions of ProClarity Desktop Professional
 * Microsoft ProClarity Web Professional 6.3 and earlier versions of ProClarity Web Professional



CAUSE
This issue occurs because of behavior that occurs if no data is returned. By default, actions that are created in Analysis Services return the headers for all columns and rows.

Keywords: kbtshoot kbexpertiseinter kbprb KB934096

-

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

© Microsoft Corporation. All rights reserved.