I use Excel XP 2002 with Analysis Server 2000. I would like to collect MDX
statements that Excel generates. How can i do ? thanks

You can edit .oqy file that defines cube data source:

http://groups-beta.google.com/group/...rver.olap/msg/
1370f8f25411bc20
To delve into the MDX query, open your *.oqy file and add "log
file=a.txt"
to the connection string.

Open a.txt with Internet Explorer, and you can see the MDX logs.

Ohjoo Kwon
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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