1) we can define member under dimension, right? If I use Excel 2002 to connect to the cube with that dimension
can we also see the member in that dimension

2) Is Excel pivot table function also has drillthrough function like what we can use in Analysis Manager?

Unfortunately not, you need to write some code to form the MDX Drillthrough statement and then send that to AS. There are several examples out there though

Naz

Here's one for the web component - there is one for excel as well - can't
remember where though...

http://www.microsoft.com/downloads/d...477-2100-4586-
a13c-50e56f101720&displaylang=en

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