Re: Analysis Services Access Log

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Dave Wickert [MSFT] (dwickert_at_online.microsoft.com)
Date: 10/12/04 

Date: Mon, 11 Oct 2004 17:05:10 -0700

Just a general comment:
The query log is not the same as an access log.
The query log contains those *aggregates* requested by the client; it does
not contain the query itself.
For example, if the client can respond to a query by using its client cache
then no entry in the query log will be written.
If the aggregate requested can be calculated at runtime from other
aggregates without reading from disk, then what will be in the query log is
just the initial client request; not the ultimate aggregates used.
The query log was designed and implemented to be part of the "usage-based
optimization" system; not a general purpose log.
Use it for other purposes at your own risk. 

-- 
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Javier Catala" <JavierCatala@discussions.microsoft.com> wrote in message
news:30B8B34D-2E7A-4DA1-88E4-6232432EBF43@microsoft.com...
> Hi everyone,
>
> I would like to know if Analysis Server stores in any place a log of all
> data access. I need to know who access to a cube, when and which data has
> been accessed.
>
> Thanks in advance.