Thursday, April 26, 2012 1:56 PM
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.
Tuesday, May 01, 2012 6:36 AM
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:
Rock Wang TechNet Community Support
- Marked As Answer by VikSrini Tuesday, May 01, 2012 2:49 PM
Tuesday, May 01, 2012 2:50 PM
Thanks Rock Wang.
I looked through the commandlets and it only had administration command lets as you mentioned.