Does this support MDX ?

Not showing but using to create...

It didn't in the previous versions but what about the new ones ?

/Michael V.

Michael,

I'm not 100% sure what you mean. Excel does of course "support MDX" in
the sense that when you use XL pivot tables to connect to a OLAP cube
XL creates an MDX query. You can view this query by logging the queries
send to the server or by showing the MDX property of the pivot table
(Xl 2002/XP or higher).

To log the queries you have to add "Log File = c:\log.txt" to the
coonnection string where c:\log.txt is the log file location. To show
the MDX property you could select a cell in the pivot table and open
the Visual Basic Editor (Tools - > Macro - > Visual Basic editor) and
type "? activecell.PivotTable.MDX" in the Immediate window.

Excel does not natively support executing an MDX query. You can also
not change the MDX string of an pivot table.

I created an Excel add in that helps showing the MDX String, editing
the connection string and even provides a simple method to execute and
show MDX queries in XL. Email me if you are interested.

Hope that helps

Thomas



Michael Vardinghus schrieb:

It was preciously the executing part.

So I cannot in code execute and mdx statement which results in a "finished"
pivottable report .... i have to do something more ?

"Thomas Greuel" <thomasgreuel (AT) hotmail (DOT) com> wrote

However Thomas

I've tried the XP web compoentn and there you can enter a commandtext when
connecting to a cube which results in a finished pivottable.

Is that possible - to use it when opening af report / form for the first
time....

Didn't have the same choice when connecting in excel - tried to put
somehting in the commandtext property in vb with no luck...

"Thomas Greuel" <thomasgreuel (AT) hotmail (DOT) com> wrote

No, not that I'm aware of.


Michael Vardinghus schrieb: