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.

Look at the Analysis Services Operations Guide at:
http://www.microsoft.com/technet/pro.../anservog.mspx
This is one of the topics discussed in the white paper.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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 (AT) hotmail (DOT) com> wrote

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 (AT) online (DOT) microsoft.com> wrote

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 (AT) online (DOT) 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 (AT) hotmail (DOT) com> wrote

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 (AT) online (DOT) microsoft.com> wrote

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 (AT) hotmail (DOT) com> schrieb im Newsbeitrag
news:u%23uUVlPgEHA.3988 (AT) tk2msftngp13 (DOT) phx.gbl...

I think a better approach might be to look at setting:
AUDIT_LOGIN
in the following white paper:
http://msdn.microsoft.com/library/de...egsettings.asp
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) 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 (AT) hotmail (DOT) com> wrote