Re: OLAP Log

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

Date: Fri, 13 Aug 2004 20:39:39 -0700

I think a better approach might be to look at setting:
AUDIT_LOGIN
in the following white paper:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql2k_anservregsettings.asp 

-- 
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.
"Matthias Englert" <menglert_news_nospam@hotmail.com> wrote in message
news:%23Ma%23BWQgEHA.2020@TK2MSFTNGP10.phx.gbl...
> You can easily analyze these informations by desinging a cube on the table
> 'querylog' in the database 'msmdqlog.mdb' that is by default created in
> C:\Program Files\Microsoft Analysis Services\Bin\.
>
> cheers,
> Matthias
>
> "Sam" <cybersam88@hotmail.com> schrieb im Newsbeitrag
> news:u%23uUVlPgEHA.3988@tk2msftngp13.phx.gbl...
> > I refer to user who connected at SQL Server 2000 Analysis Manager (OLAP
> > Cube) and what cube does user access.
> >
> > I need the username, login date, login time, login OLAP cube and logout
> > date, logout time.
> >
> >
> >
> > "Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in message
> > news:O%23IbZHNgEHA.3548@TK2MSFTNGP09.phx.gbl...
> > > It depends on what you are looking for. Are you looking to determine
> what
> > > users are connected to your server? Or are you looking to log their
MDX
> > > queries? Or something different. "Logging" can mean many things.
> > > -- 
> > > 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.
> > >
> > > "Sam" <cybersam88@hotmail.com> wrote in message
> > > news:uDyFuGBgEHA.1972@TK2MSFTNGP09.phx.gbl...
> > >> Thanks for the article.
> > >>
> > >> But the log is subjected to changes / processing of SQL Server
Analysis
> > >> Manager 2000.
> > >>
> > >> How about those user who access the OLAP Cube via Excel Pivot Table?
> > >>
> > >>
> > >>
> > >>
> > >> "Dave Wickert [MSFT]" <dwickert@online.microsoft.com> wrote in
message
> > >> news:edGF$G2fEHA.1092@TK2MSFTNGP11.phx.gbl...
> > >> > Look at the Analysis Services Operations Guide at:
> > >> >
> > >>
> > >
>
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
> > >> > This is one of the topics discussed in the white paper.
> > >> > -- 
> > >> > 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.
> > >> >
> > >> > "Sam" <cybersam88@hotmail.com> wrote in message
> > >> > news:OELhdrnfEHA.2544@TK2MSFTNGP10.phx.gbl...
> > >> > > May I know how to create log for monitoring SQL Server Analysis
> > > Manager
> > >> > > 2000, please?
> > >> > >
> > >> > > I had developed OLAP via Excel but I would like to know OLAP
> > >> > accessibility.
> > >> > >
> > >> > > Please advise.
> > >> > >
> > >> > >
> > >> > >
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Olap Cube Documentation
    ... > You can run it from any workstation which has network access to the cube. ... >> Program Manager ... >> BI SystemsTeam ... >> rights. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: OLAP Log
    ... You can easily analyze these informations by desinging a cube on the table ... > I need the username, login date, login time, login OLAP cube and logout ... > date, logout time. ... >> Program Manager ...
    (microsoft.public.sqlserver.olap)
  • 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: Drillthrough sample for visual basic 6
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... "Mario Gherardi" wrote in message ... >> the MDX command by catching some ... >>> Program Manager ...
    (microsoft.public.sqlserver.olap)
  • Re: DSO ERROR
    ... The PPU goes to great pains to prevent that from ... > With regards to whether or not two users can be processing the same cube; ... > Program Manager ... >> their partition randomly.(It means they maybe process their partition ...
    (microsoft.public.sqlserver.olap)