RE: Analysis Services Access Log

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: HWUK (HWUK_at_discussions.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 04:07:02 -0700

Untill you upgrade to AS 2005 the data from these logs are reasonable
limited. Usually (by default) you only see every 10th login, and unless your
very good you can only see which user used which cube at what time and for
how long, Saying that this data becomes obscured by them accessing AS form
several sources in parrallel. The dimension information is there but
exceptionally hard to determin.

At the moment I only use the Log as a general user/usage performance
indicator and to see who was on during an "Exceprion violation".

"Javier Catala" wrote:

> 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.

Relevant Pages

  • Re: SQL CE 3 and CF 1.0 support
    ... > We have designed our application so that all data access logic is ... > using our automated upgrade mechanism and at the same time upgrade the ... > from the engine download and the database upgrade delay). ... > I also know of applications that have been using SQL CE databases in RAM ...
    (microsoft.public.sqlserver.ce)
  • Re: OWC: Export to Excel
    ... From the moment I create the second cube, the login box keeps ... able to create multiple pivottables which connect to the same cube. ... I made a copy of the first sheet where the pivottable is on. ...
    (microsoft.public.sqlserver.olap)
  • Re: SQL CE 3 and CF 1.0 support
    ... We have designed our application so that all data access logic is ... using our automated upgrade mechanism and at the same time upgrade the ... from the engine download and the database upgrade delay). ... I also know of applications that have been using SQL CE databases in RAM and ...
    (microsoft.public.sqlserver.ce)
  • RE: Analysis Services Access Log
    ... I just open QueryLog table, and there is a column named "Dataset". ... > exceptionally hard to determin. ... >> data access. ... I need to know who access to a cube, ...
    (microsoft.public.sqlserver.olap)
  • Re: Fast User Switching: Any Technical Gotchas?
    ... login window takes under a second to appear after the cube animation, ... It's not the after cube stuff, it's the wait between selecting the menu ... option and then the login dialog appearing. ... "Hard as nails, hard as nails - So would you be if you lived one hundred ...
    (uk.comp.sys.mac)