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.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | JoozhPosting 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 |  |  
                                    | rockmooseSQL 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 |  
                                          |  |  |  
                                    | JoozhPosting 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 |  
                                          |  |  |  
                                |  |  |  |