Enable Chart Web Part in SharePoint 2013

The SharePoint Chart Webpart was deprecated. But its still available in 2013.

Steps:

  1. Login to any farm server hosting SharePoint as a Site Collection Administrator.
  2. Go to: Settings > Site Settings > Go to top level site settings > Web Designer Galleries > Web parts.
  3. Click the FILES tab.
  4. Click New Document.
  5. Scoll down the list and look for: Microsoft.Office.Server.WebControls.ChartWebPart.
  6. Check this item.
  7. Scroll back up to the top, and then click the Populate Gallery button.
  8. Wait for it to refresh.
  9. Scoll down the list and look for: ChartWebPart.webpart.
  10. Click its Edit button.
  11. Enter the value, Content Rollup, or enter any other web part group value appropriate to your needs.
  12. Click Save.
  13. That’s it.  The next time you open a web page in edit mode and search for a web part to add to it, you’ll see the Chart web part there.

SharePoint 2013 BI on mobile devices

We can build our mobile BI solutions based on SQL Server as a data source in the following (different) ways:

  • IIS (Internet Information Services; as a very low cost solution): SSRS (SQL Server Reporting Services; note: limited use for the Apple platform, details are described below)
  • SharePoint Server: Excel Services (easier solutions), SSRS integrated mode, PerformancePoint Services (much more complex solutions)
  • OWA Server (Office Web Apps): Excel
  • 3rd party developer tools/platforms or ready-to-use solutions

In a few bullets below, there are described the results of my investigation about some possibilities for mobile BI solutions based on the SQL Server platform.

Mobile BI (iPad/iPhone, Android, Windows 8/Phone devices) platform:

1. IIS:

  • SSRS:
  • iPad: Safari/Chrome/Opera – NO,  FF/IE – not supported
  • Android: FF – OK, Chrome/Opera – NO, Safari/IE – not supported
  • Windows 8: IE – OK, alternative – FF, Chrome/Opera – NO, Safari – not supported on tablet?

 

2. SharePoint 2013:

  • Excel Services:
    • iPad: Safari – OK (note: slicers – OK), alternatives – Chrome/Mercury (Chrome and Firefox alternative), Opera – NO, FF/IE – not supported
    • Android: FF – OK (note: slicers – NO), Chrome/Opera/(Built-in Browser/Dolphin) – NO, Safari/IE – not supported
    • Windows 8: IE – OK, alternatives – FF/Chrome/Opera, Safari – not supported
  • PerformancePoint Services (Dashboards):
  • OLAP/Excel Services:
    • iPad: Safari – OK (note: slicers – OK), alternatives – Chrome/Mercury (Chrome and Firefox alternative), Opera – NO, FF/IE – not supported
    • Android: FF – OK (note: slicers – NO), Chrome/Opera/(Built-in Browser/Dolphin) – NO, Safari/IE – not supported
    • Windows 8: IE – OK, alternative – FF, Chrome/Opera – OK (note: zoom – NO), Safari – not supported
  • SSRS:
    • iPad: Safari/Chrome/Opera – NO, Mercury (Chrome and Firefox alternative) – NO, FF/IE – not supported
    • Android: FF – OK, Chrome/Opera/(Built-in Browser/Dolphin) – NO, Safari/IE – not supported
    • Windows 8: IE – OK, alternative – FF, Chrome/Opera – NO, Safari – not supported on tablet?
  • PowerPivot/PowerView: the output is rendered in Silverlight
    • iPad: SL – not supported on iOS (note: SL is available only for Windows and Mackintosh)
    • Android: SL – not supported
    • Windows 8: IE – OK, alternatives – FF/Chrome/Opera (note: scroll – NO), Safari – not supported

 

BI Resources and Links

Here’s a list of blogs that has helped me configure Power Pivot for SharePoint 2010 and 2013

SharePoint 2013 Kereberos setup http://blog.blksthl.com/2012/09/26/the-first-kerberos-guide-for-sharepoint-2013-technicians/#step4

Installing 2013 BI features : http://blogs.msdn.com/b/querysimon/archive/2012/11/26/installing-the-bi-features-of-sharepoint-2013.aspx

Installing 2010 BI features: http://blog.cloudshare.com/2012/05/22/step-by-step-guide-to-installing-sharepoint-with-sql-2012-powerpivot-powerview-and-reporting-services/

another 2010 BI blog: http://blogs.msdn.com/b/karang/archive/2012/04/13/step-by-step-guide-of-installing-power-view-with-powerpivot-2012.aspx

Notes: things get tricky in a multi server farm. the SQL install will have all the features needed for SharePoint. For SharePoint 2013 there is a spPowerPivot.msi you can use on the WFEs instead of the SQL server install.