none
Drillthrough Action not available - removed from Excel 2003? RRS feed

  • Question

  • Thinking that Excel 2003 (latest SP3) could handle SSAS (2005 SP3) Cubes fine because they create PivotTables fine and I've seen drillthroughs at sites like http://www.databasejournal.com/features/mssql/article.php/10894_3643336_4/Actions-in-Analysis-Services-2005--The-Drillthrough-Action.htm. Was about to roll it out to finance when realised that the Drillthrough Actions (which can be  used fine from a quick Management Studio Cube Browse) were not available!

    So I looked for the Excel 2002/2003 Add-in for SQL Server Analysis Services at http://www.microsoft.com/downloads/en/details.aspx?FamilyID=dae82128-9f21-475d-88a4-4b6e6c069ff0 where it says it's been "removed... to reduce confusion"!

    I did get hold of a copy of the Add-In and it works for it's own functionality, but still does not provide the Drillthrough Option when right-clicking a cell anyway. So maybe I am missing something else?

    Can somebody provide confirm what is possible here, surely you can use the SSAS Drillthrough Action on Excel 2003?

    Phil

    Friday, January 21, 2011 8:49 AM

Answers

All replies

  • It's not available in Excel 2003, you can try to invoke cube drillthrough action from Excel 2003 like below document described:

    http://msdn.microsoft.com/en-us/library/aa155755(office.10).aspx

     

    • Marked as answer by TickboxPhil Monday, February 28, 2011 12:35 PM
    Monday, January 24, 2011 2:36 AM
  • Thanks for your conf! How irritating for Microsoft to remove it, am sure it was there originally when they were promoting SSAS!

    The OWC link you give doesn't work on Office 2003, only 2000 - there's a version for that at http://www.microsoft.com/downloads/en/details.aspx?familyid=beb5d477-2100-4586-a13c-50e56f101720&displaylang=en but basically, I remember this OWC from years ago and it was deprecated too - it's mainly for viewing through a web page not Excel so the amount of problems I will come across kind of rule it out.

    Anybody else got it to work (Excel 2003 is still a big corp standard unfortunately)? Otherwise it's back to the 3rd party stuff, Phil

    Tuesday, January 25, 2011 6:43 PM