SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to get the values from a scorecard in PerformancePoint/SharePoint 2010.

I have setup the code below. This fetches the objects just fine from PerformancePoint

BIMonitoringAuthoringServiceSoapClient client = new BIMonitoringAuthoringServiceSoapClient("BIMonitoringAuthoringServiceSoap");

client.ClientCredentials.Windows.ClientCredential = new System.Net.NetworkCredential("xxx", "xxx", "xxx");
client.ClientCredentials.Windows.AllowedImpersonationLevel = TokenImpersonationLevel.Identification;

string listUrl = "/ops/Dashboards/Lists/PerformancePoint Content/";
FirstClassElement[] fcos = client.GetListItems(listUrl);

Kpi kpi = client.GetKpi(new RepositoryLocation() { ItemUrl = "/ops/Dashboards/Lists/PerformancePoint Content/27_.000" });
string kpimdx = client.GetMdx(new RepositoryLocation() { ItemUrl = "/ops/Dashboards/Lists/PerformancePoint Content/27_.000" });

Scorecard scorecard = client.GetScorecard(new RepositoryLocation() { ItemUrl = "/ops/Dashboards/Lists/PerformancePoint Content/38_.000" });
string scorecardmdx = client.GetMdx(new RepositoryLocation() { ItemUrl = "/ops/Dashboards/Lists/PerformancePoint Content/38_.000" });

The question is what how can you get the actual/target/state/etc from the scorecard?

Note: I started looking for MDX that might be behind the control, so I could query analysis services myself.

The KPIs/Scorecard don't seem to have MDX directly accessible via the client.GetMdx function.

Also I didn't mention that BIMonitoringAuthoringServiceSoapClient comes when I setup a WCF service to PMService.

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.