Thursday, April 14, 2011

How to enable SharePoint 2010 Web Analytics "Custom Report"

After we evaluated and put the design together to enable SharePoint 2010 web analytics reports in November 2010 as described in previous blog, we have seen many power users try to use the reports. However, we have identified several issues that is preventing end users to get meaningful reports.

The first mystery to us is SharePoint 2010 provides a "Custom Report" users could schedule to generate the customized reports based on users criteria.  However some site collection reports such as "Top Pages" is missing "Custom Report" button on the ribbon. We have identified this is only happening on some sites for some environments not all sites. You could refer the two pictures with and without "Custom Report" button. listed in previous bog.

While debugging this inconsistent issue across different environments and different sites, we have finally identified the issue. Here is the summary of root cause, procedure to verify, and command to to fix it.

1. Root cause: The root cause is there is hidden site feature named WACustomReports needs to be enabled in order for users to see "Custom Report" button. You could check this from 14 hive directory
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\FEATURES\WACustomReports.

<Feature  Id="AF6D9AEC-7C38-4dda-997F-CC1DDBB87C92"
          ReceiverAssembly="Microsoft.Office.Server.WebAnalytics.UI, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

 2. Procedure to check. You could use the following powershell commend to verify whether you have this feature enabled on site collection.

Get-SPFeature -Site http://sitecollectionurl

If you have the feature enabled, you will see the following entry.
DisplayName                                               Id                                              Scope
-----------                                                   --                                               -----
WACustomReports                af6d9aec-7c38-4dda-997f-cc1ddbb87c92     Site

3. Commend to fix this if not already activated. Here is the commend to enable this feature so users could have the "Custom Report" button.

Enable-SPFEATURE WACustomReports –URL http://sitecollectionURL

Now you should have the "Custom Report" you could enjoy to use. We were working with Microsoft how we could enable this for all sites automatically. There is a thread on this already from MSDN.

I looked at issue again this week  April 26 2011, I realized that this feature is automatically enabled for sites created from OoB site definition. However, if you have your own site definition or template, you need to add this feature to the feature stapling to enable it after site created.


  1. Thank you for this. Solve my problem!

  2. Excellent pieces. Keep posting such kind of information on your blog. I really impressed by your blog.
    SEO tools

  3. I followed the instructions and if I try to run the enable a second time I get a message that says it's already enableed. However I do not see the button in the application and I don't have that left nav like I see in other posts for the reports in your other blog pages. Is there something else I need to do?

    1. What I needed was a bit of patience for the timers to kick in!

  4. The word is "command" not "commend"
    "Commend" means to give praise for or endorse an action.

  5. ?? The Feature is not a Farm Level Feature and is not found in a Site level defined by the Url http://mySPserver:12345 ???

    Please help

  6. still can't see the button after enabling the WACustomReports feature. any idea what I am missing?

  7. i had tried how you had informed but also i could able to see the Custom Report" button on my page can any one help on this..