from a user monitoring standpointe - can we know if the cube was being accessed by ssrs or by excel? Any DMv's? profiler? what can we should try?

Thanks you.

Hi

To my knowledge, we have SSAS DMV to get the current session and commands but not the history of all access information (I wish, I could be wrong)

Try these for current information

SELECT * FROM $system.DISCOVER_CONNECTIONS 

SELECT * FROM $system.DISCOVER_SESSIONS

SELECT * FROM $system.DISCOVER_COMMANDS

Here is one interesting activity monitor tool though I never tried (preferred with DMV)

http://asactivityviewer2008.codeplex.com/releases/view/15786

Look into this thread for information. http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9b397d28-8a1c-4d55-95d7-fae7d93ade96/ssas-cube-users-application-tracking