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

You looked on the client machine? Logging is done in PTS which is a
client-side component.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Rouven Hertenstein" <RouvenHertenstein@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:5BD0F3F8-BD6E-4F53-B5F0-1274AED7D1AE@xxxxxxxxxxxxxxxx
> 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: Logging on Olap from different domain
    ... Security Administration ... > Program Manager ... > BI SystemsTeam ... > SQL BI Product Unit ...
    (microsoft.public.sqlserver.olap)
  • Re: Weird : More than the maximum of 64,000 dimension member
    ... > Program Manager ... > BI SystemsTeam ... > SQL BI Product Unit ... reprocessing the cube as I mentioned I am doing a incremental load ...
    (microsoft.public.sqlserver.olap)
  • Re: PTS Version
    ... Natively on the service pack, the distribution files are located in the ... >> Program Manager ... >> BI SystemsTeam ... >> SQL BI Product Unit ...
    (microsoft.public.sqlserver.olap)
  • Sql Express (Merge Subscriber) / SQL Server 2000 (Merge Publisher)
    ... Previously we were running MSDE on a client machine and SQL Server 2000 at ... running the Merge ActiveX Control or running a COM enabled control with RMO. ...
    (microsoft.public.sqlserver.replication)
  • Re: OpenDataSource connection problem
    ... Access is on the client machine. ... You have to work out why Access (sql server, ... application/Access database on a client machine, ...
    (microsoft.public.access.queries)