Actually, you can log the MDX used by PT services on the client side. Find
the .oqy file that is used for the cube (normally these are in c:\documents
and settings\sernameapplication data\microsoft\queries). Then add Log
File=ilespecto the line that starts with "Connection" , where ilespec
is a file name with path and an extension of .log or .txt
(c:\temp\olaplog.txt, for instance).
This will write any MDX queries used by pivot tables using that .oqy file to
the log file.