LogFile-Setting in the oqy-file don't work

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
I access an OLAP-Cube (located on a SQL Server 2005) via Excel 2003
PivotTable. Now, I want to get a logfile, which should comprise the
mdx-queries created by the Excel PivotTable.

The .oqy-File lookes like this:
=======================================
QueryType=OLEDB
Version=1
CommandType=Cube
Connection=Provider=MSOLAP.3;Cache Authentication=False;Integrated
Security=SSPI;User ID="";Initial Catalog=Cube;Data
Source=testserver;Impersonation
Level=Impersonate;Location=testserver;Mode=ReadWrite;Protection Level=Pkt
Privacy;Auto Synch Period=20000;Default Isolation Mode=0;Default MDX Visual
Mode=0;MDX Compatibility=0;MDX Unique Name Style=0;Non Empty
Threshold=0;SQLQueryMode=Calculated;Safety Options=1;Secured Cell
Value=0;SQL Compatibility=0;Compression Level=0;Real Time Olap=False;Packet
Size=4096; Log File=C:\tmp\mdx.txt
CommandText=Datawarehouse
=======================================

Why doesn't it write anything in the "mdx.txt"-Logfile?! I can't see any
failings.

Thanks for your helping.

Regards,
Rouven
.

Relevant Pages

  • Re: Awk Array Question
    ... hr)}' ${logfile}> $.csv ... Excel. ... I want to truncate the output to only output the max value in ...
    (comp.unix.shell)
  • Excel Generated Errors & will close
    ... "Excel generated errors and will close. ... a logfile has been created." ... located on the intranet. ... Eijaz ...
    (microsoft.public.internet.explorer.ieak)