PerformancePoint Monitoring Web Service - Part 1

re: PerformancePoint Monitoring Web Service - Part 1

john.brookmyre — Tue, 07 Apr 2009 14:37:55 GMT

I have been a fan of the site for some time and wonder if you can help with this - We are trying to replicate some functionality in Performance Point which works in Reporting Services (2005). What we want to be able to do is direct the user to a particular cube on a particular server depending on their username. Here is an example of how we would do this in SSRS (on SQL Central) - www.sqlservercentral.com/.../2945.

As ever any assistance would be much appreciated,

John

twitter.com/brookmyre

PerformancePoint Monitoring Web Service - Part 3

Tim Kent's blog — Fri, 22 Aug 2008 16:47:24 GMT

In Part 1 we looked at the basics of connecting to web service and retrieving the metadata.  Part

PerformancePoint Monitoring Web Service - Part 2

Tim Kent's blog — Thu, 24 Jul 2008 11:32:34 GMT

In my last post we looked at the basics of connecting to the web service and using some simple functions

re: PerformancePoint Monitoring Web Service - Part 1

Tim Kent — Thu, 10 Jul 2008 09:51:27 GMT

Hi Kurinji

Adding a name for any new object is not straightforward! Part 2 (coming soon) will look at both the issues you mention. Just need to find the time to finish the post!!

Tim

re: PerformancePoint Monitoring Web Service - Part 1

Tim Kent — Thu, 10 Jul 2008 09:36:16 GMT

Thanks Heiner

There is no functionality within the web service to access the values but you can access the MDX. This is stored in the customdata property of the kpi. You could then write a helper class to go and retrieve the values. I'll try and look at this in one of the next posts

re: PerformancePoint Monitoring Web Service - Part 1

Kurinji — Thu, 10 Jul 2008 06:59:16 GMT

Good start to get to know about the PPS API.

I tried out similar methods for create operation where i am facing difficulties (like not able to give name for a KPI and linking actual/ target to a datasource).

Any pointers on this?

re: PerformancePoint Monitoring Web Service - Part 1

Heiner Roth — Tue, 03 Jun 2008 10:03:10 GMT

Great Article Tim.

Do you see any chance to use this approach to get/read

the current status/score of a Kpi and his target(s)?

re: PerformancePoint Monitoring Web Service - Part 1

Kevin Idzi — Sat, 31 May 2008 03:56:46 GMT

The API is great, and as an FYI, on codeplex there is a project which uses those same Webservice apis to automate the deployment between servers of the PPS elements - changing Proclarity links, sharepoint links, etc.

So you can go to the URL www.codeplex.com/bipublisher for even more samples on modifying elements within monitoring webservice.