SharePoint 2010 Analytics Reports coming up blank when customizing?
I was recently evaluating the web analytic reporting capabilities within SharePoint 2010 and ran into a strange problem. Although the reports were displaying correctly they would appear blank if I attempted to “Customize” them. After spending a few hours scouring the Internet and reading different posts and solutions I was able to piece together a solution that resolved it for me.
If you attempt to customize a web analytic report in SharePoint 2010 and it comes up blank, make sure you have done the following:
- Started the Claims to Windows Token Service via Central Admin > Application Management > Manage services on server
- Verify the User Defined Function Assemblies via Excel Service Application has a reference to Microsoft.Office.Server.WebAnalytics.UI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c (Assembly Location is Global Assembly Cache).
If any one of these is not setup correctly, your reports will show up blank when you view them via Excel in browser or in client. Once you have these two things configured correctly, reports display perfect!
Pingback: SharePoint Tips - Secrets of SharePoint -