0

I am using SharePoint Designer 2010. When I create a new scorecard, Dashboard Designer gives option to import existing KPIs from Analysis Service. So if I make any changes to these KPIs in Analysis Service, then I create new scorecard and import the KPI. Is there any way to import the KPIs directly to Dashboard Designer without creating new scorecard.

Thanks in Advance, Merin

Merin Nakarmi
  • 3,148
  • 3
  • 35
  • 42

1 Answers1

0

Create a new blank KPI --> Change the KPI data mapping to your SSAS data source --> Use a custom MDX tuple formula to reference your SSAS KPI's.

The tuple formulas you can use to get KPI data are KPIValue("[kpi name]"), KPITarget("[kpi name]"), KPIGoal("[kpi name"]), KPITrend("[kpi name"]).

Ola Ekdahl
  • 1,484
  • 1
  • 11
  • 21