Hi everyone!

I have a problem with showing details in client. I enable drillthrough in Analysis Services and I have no problem viewing details. Also I have no problem viewing details in Proclarity, but when I make Pivot table in Excel XP I get message: Cannot show details for this selection.
When I look at table options, the checkbox 'Enable drill to detail' is checked but disabled.

What can I do to see details in my Pivot table?

Uros

Uros,

option Enable drill to detail is disabled if the source data is from OLAP ->
your case AS.


Peace,
Andrej


"Uros" <anonymous (AT) discussions (DOT) microsoft.com> wrote

problem viewing details in Proclarity, but when I make Pivot table in Excel
XP I get message: Cannot show details for this selection.

There is sample VBA add-in code that allows OLAP drill-through from
Excel Pivot Table cells - it has been discussed earlier on this group.
Here is the link to an MSDN article: "Extending Excel OLAP
Functionality":

http://msdn.microsoft.com/library/de.../en-us/dnexcl2
k2/html/odc_xlextendolap.asp


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!