Pivot table - Show Detail

#1

I had asked this question earlier. now I am just gonna rephrase it a
bit.

I have an Excel Pivot table that accesses an AS 2000 cube on the
server. I am not able to view the details ...usually it opens up
another worksheet and displays the exploded data (in a regular Sql
Server database)

is this even possible?

#2

It is, but you have to add custom code:

http://msdn.microsoft.com/library/de...extendolap.asp

Bjoern

<weirdscientist78 (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1152718785.789014.24160 (AT) s13g2000cwa (DOT) googlegroups.com...

Quote:

I had asked this question earlier. now I am just gonna rephrase it a
bit.

I have an Excel Pivot table that accesses an AS 2000 cube on the
server. I am not able to view the details ...usually it opens up
another worksheet and displays the exploded data (in a regular Sql
Server database)

is this even possible?

#3

thank you very much.

I am looking into the article you provided.

thanks again.

WS

bjh wrote:

Quote:

It is, but you have to add custom code:

http://msdn.microsoft.com/library/de...extendolap.asp

Bjoern

weirdscientist78 (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1152718785.789014.24160 (AT) s13g2000cwa (DOT) googlegroups.com...
I had asked this question earlier. now I am just gonna rephrase it a
bit.

I have an Excel Pivot table that accesses an AS 2000 cube on the
server. I am not able to view the details ...usually it opens up
another worksheet and displays the exploded data (in a regular Sql
Server database)

is this even possible?

#4

Hi there,

actually, all we apparently need to do is install Excel add-in for
analysis services.

right click on a cell and select OLAP Drillthough and you should get
your exploded data...hopefully...

WS

weirdscientist78 (AT) gmail (DOT) com wrote:

Quote:

thank you very much.

I am looking into the article you provided.

thanks again.

WS

bjh wrote:
It is, but you have to add custom code:

http://msdn.microsoft.com/library/de...extendolap.asp

Bjoern

weirdscientist78 (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1152718785.789014.24160 (AT) s13g2000cwa (DOT) googlegroups.com...
I had asked this question earlier. now I am just gonna rephrase it a
bit.

I have an Excel Pivot table that accesses an AS 2000 cube on the
server. I am not able to view the details ...usually it opens up
another worksheet and displays the exploded data (in a regular Sql
Server database)

is this even possible?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Pivot table - Show Detail

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

Pivot table - Show Detail - 07-12-2006 , 10:39 AM

Re: Pivot table - Show Detail - 07-12-2006 , 12:21 PM

Re: Pivot table - Show Detail - 07-13-2006 , 10:28 AM

Re: Pivot table - Show Detail - 07-17-2006 , 10:49 AM