Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Is it possible toget a usage log of my cubes

Author  Topic 

Joozh
Posting Yak Master

145 Posts

Posted - 2004-12-05 : 23:17:06
Hi,

I have managed to setup some cubes on the server, have roles defined, and users are using these and the results are mathcing...

Is there a way that I can get some sort of user based usage log of the cubes andget details of when and what type of data did any user see/make use of?

I'll appreciateany help in this regard.

Thanks & Regards.

-J

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2004-12-06 : 10:08:21
See this:
[url]http://www.sqlservercentral.com/columnists/rbalukonis/analysisaboutanalysisservices.asp[/url]
The author has another article on which dimensions were used as well.

rockmoose
Go to Top of Page

Joozh
Posting Yak Master

145 Posts

Posted - 2004-12-13 : 23:53:08
HI rockmoose,

Sorry for the late reply but Iwanted to thank you for the URL. I found it quite useful and though I am still having some problems becuase I process my cubes daily (and becuase of that the logs get deleted????)... Any clues regarding hwythis happens and if there is a solution to stop this from happening?

However the solution in thearticle that you have shared will hopefully help me find a solution.

So many many thanks (really) for sharing the article.


Thanks & Regards.

-J
Go to Top of Page
   

- Advertisement -