Excel and Excel OWC

#1

Hi all
I am comparing Excel Desktop Pivot tables and The Office pivot table OWC.
In the OWC we can define a custom MDX query and get the results in the Pivot
table.
Is there a way we can do this in the Desktop Excel ? (it's important the
query return in a PIVOT TABLE).
Surely there is some way to achieve it since I can execute a custom MDX in
the OWC and export it into the desktop excel ! Somewhere in there is a query
I can not find/set...

Omer

#2

Unbelievably, no.

tom @ the domain below
www.tomchester.net

"Muhammad Omer [Xavor]" <momer (AT) xavor (DOT) com> wrote

Quote:

Hi all
I am comparing Excel Desktop Pivot tables and The Office pivot table OWC.
In the OWC we can define a custom MDX query and get the results in the
Pivot
table.
Is there a way we can do this in the Desktop Excel ? (it's important the
query return in a PIVOT TABLE).
Surely there is some way to achieve it since I can execute a custom MDX in
the OWC and export it into the desktop excel ! Somewhere in there is a
query
I can not find/set...

Omer

#3

Wierd,
How sure are you on this tom ?

Omer

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Quote:

Unbelievably, no.

tom @ the domain below
www.tomchester.net

"Muhammad Omer [Xavor]" <momer (AT) xavor (DOT) com> wrote in message
news:uzfEeX%23hDHA.1480 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi all
I am comparing Excel Desktop Pivot tables and The Office pivot table
OWC.
In the OWC we can define a custom MDX query and get the results in the
Pivot
table.
Is there a way we can do this in the Desktop Excel ? (it's important the
query return in a PIVOT TABLE).
Surely there is some way to achieve it since I can execute a custom MDX
in
the OWC and export it into the desktop excel ! Somewhere in there is a
query
I can not find/set...

Omer

#4

100% sure. Here's an article that delves in:

http://www.tomchester.net/articlesdo...whyselect.html

tom @ the domain below
www.tomchester.net

"Muhammad Omer [Xavor]" <momer (AT) xavor (DOT) com> wrote

Quote:

Wierd,
How sure are you on this tom ?

Omer

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote in message
news:z3veb.518$W7.80550 (AT) news (DOT) uswest.net...
Unbelievably, no.

tom @ the domain below
www.tomchester.net

"Muhammad Omer [Xavor]" <momer (AT) xavor (DOT) com> wrote in message
news:uzfEeX%23hDHA.1480 (AT) TK2MSFTNGP12 (DOT) phx.gbl...
Hi all
I am comparing Excel Desktop Pivot tables and The Office pivot table
OWC.
In the OWC we can define a custom MDX query and get the results in the
Pivot
table.
Is there a way we can do this in the Desktop Excel ? (it's important
the
query return in a PIVOT TABLE).
Surely there is some way to achieve it since I can execute a custom
MDX
in
the OWC and export it into the desktop excel ! Somewhere in there is a
query
I can not find/set...

Omer

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

Excel and Excel OWC

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

Excel and Excel OWC - 10-01-2003 , 12:05 AM

Re: Excel and Excel OWC - 10-01-2003 , 02:07 AM

Re: Excel and Excel OWC - 10-01-2003 , 02:23 AM

Re: Excel and Excel OWC - 10-01-2003 , 09:40 AM