OData, SharePoint Lists and PerformancePoint Server

A colleague of mine Alan Whitehouse blogged about SharePoint Lists as data sources for PerformancePoint Services, you can find his post here.

PerformancePoint Services, SharePoint Lists and Business Connectivity Services.

After reading his blog I was inspired to:

  • Create a WCF web service that consumes the public Netflix oData feed
  • Create a SharePoint External Content Type in SharePoint Designer
  • Create an External Content List in SharePoint
  • Use that list as a source for PerformancePoint Items

Below is the Result, a very simple visualization displaying the Movie, Short Synopsis and Netflix Url