dbTalk Databases Forums  

Drill Thru from Excel

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Drill Thru from Excel in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Suresh Kumar
 
Posts: n/a

Default Drill Thru from Excel - 05-24-2005 , 08:39 AM






I have turned on the Drill through option for a cube and it works fine from
the 'Browse data' option for looking at the fact table entries.

Some of the managers are accessing the same cube from Excel spreadsheets.

Is there an option to look at fact table entries as a Drill through from
Excel ?
If so what are the steps to do it?



Reply With Quote
  #2  
Old   
Alejandro Leguizamo \(MVP\)
 
Posts: n/a

Default Re: Drill Thru from Excel - 05-25-2005 , 11:13 AM






Take a look at
http://msdn.microsoft.com/library/de...illthrough.asp

Hope this helps

--


Alejandro Leguizamo
MIcrosoft SQL Server MVP
www.microsoft.com/mvp
Colombia



"Suresh Kumar" <skumarNoSpamATpcdiDOTcom> wrote

Quote:
I have turned on the Drill through option for a cube and it works fine from
the 'Browse data' option for looking at the fact table entries.

Some of the managers are accessing the same cube from Excel spreadsheets.

Is there an option to look at fact table entries as a Drill through from
Excel ?
If so what are the steps to do it?





Reply With Quote
  #3  
Old   
Vini
 
Posts: n/a

Default Re: Drill Thru from Excel - 05-27-2005 , 01:31 AM



You can try this Drillthrough sample : http://www.mosha.com/msolap/util.htm



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.