OLAP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

vidas,

Drillthrough is working with add-ins. But look & feel and navigations are not stright like clasic way. Need to educate end users. Thanks for your lead.

Kir




Your Reply
-----------
Kir,

I do not know if you can make SSAS 2005 drillthrough to work in Excel 2003.
I know it works in 2007.
With SSAS 2000 and Excel 2003 Microsoft had addin for drillthrough:
http://office.microsoft.com/en-us/excel/HA011265551033.aspx
But I have not tested if it works with SSAS 2005. My guess is that it will
not work.

If you will try this addin, please post here your test results.

Vidas Matelis

http://www.ssas-info.com



EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
.

Relevant Pages

  • Drillthrough in SQL Server Analysis Services 2005
    ... Is the old drillthrough functionality gone with SSAS 2005? ... measures and dimension attributes. ...
    (microsoft.public.sqlserver.olap)
  • Re: SSAS 2005 drillthrough from excel 2003
    ... I do not know if you can make SSAS 2005 drillthrough to work in Excel 2003. ... Is there any setup do I need to do in excel in order to get the drill through? ...
    (microsoft.public.sqlserver.olap)
  • OWC Drillthrough on SSAS 2005 Cube
    ... SSAS2005 cube? ... I currently use OWC10 to view data in an AS2000 cube and the drillthrough ... I've recreated my cubes in SSAS 2005, ...
    (microsoft.public.office.developer.web.components)