I am using Excel 2007 to connect to a SQL Server 2008 Analysis Services database.
I have defined a drill-through action that it works perfectly through Excel when I have selected only item selected in a filter in the pivot table. However, when I select multiple values in the filter the action doesn't even show up on right
clicking and going to the Actions menu item. The Actions menu item is disabled.
Is this an Excel bug? Is there another way to set up the SSAS Action? Why would selecting multiple items in a filter affect a drilldown action?
View Complete Post