PPS Dashboards data from SharePoint 2010 lists?

Question

We have SharePoint 2010. We have lists where are numerical data stored. We are currently using excel services to display data in SharePoint

Is is possible for and PPS Dashboards to get data from lists? What is needed? Web service is only option? Any examples code or step by step instructions?

---

Kenny_I

Answer 1

Hi Kenny_I,

Yes, we can use SharePoint list as data source in SharePoint PerformancePoint Services Designer. For the detailed steps, please see:
Create a SharePoint List data connection (PerformancePoint Services)

Additionally, here is an example of creating simple budget KPIs using SharePoint Lists data source:
Creating simple budget KPIs from SharePoint Lists

Hope this helps.

Regards,
Mike Yin

If you have any feedback on our support, please click here

---

Mike Yin
TechNet Community Support