Performance Point data source verification post deployment via powershell on SharePoint 2010

Question

We use Performance Point exclusively with Sharepoint for dashboards.I am looking to run a script ( power shell or other) to run through all data sources post deployment in the Performancepoint data connection library hosted on SharePoint to check connection properties for data sources and then write to a log file.

Is there such a script? From what I have read, the only way to connect to PPS data sources is via dashboard designer.

Thanks in advance.

Answer 1

Hi,

Based on my knowledge, SharePoint 2010 built-in PowerShell can only perform administration tasks.

PerformancePoint Services uses two web services at the site-collection level to perform authoring and rendering tasks.

• The PPSAuthoringService web service is used by Dashboard Designer to create, modify, and delete dashboard objects, retrieve dashboard content, and retrieve data from data sources.
• The PPSRenderingService web service is used by Dashboard Designer and the browser to render dashboard objects.

You can check connection properties for data sources and then write to a log file through object model. For more information about PerformancePoint Web Services, check out the following article:

http://msdn.microsoft.com/en-us/library/ee554986.aspx

Thanks,

Rock Wang

---

Rock Wang TechNet Community Support

Answer 2

Thanks Rock Wang.

I looked through the commandlets and it only had administration command lets as you mentioned.