Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.