SAS OLAP Cube Auditing

[McDiddles]

HI All, 

My EVM is broken and I was asked to find out how users interacted with the OLAP Cubes for the past 4 month. 

Data requested: 

-Username

-Cube access

-Month

-Number of times accessed

-Wether through Excel or Web-tier. 

All the information might not be available, but I will take whatever I can get.

[Mark_sas]

I would check out what you can find in the OLAP Server log file itself.  The rolling logs for this server should be located under your Configuration Directory at SASApp/OLAPServer/logs.

[McDiddles]

I was hoping there would be another easier efficient way.

I, look at the logs and see if I can put together a script to extra the meangful information that I need.