Create KPI in Dashboard Designer sharepoint 2010

In continuation with my earlier post about How to create a blank scorecard in this post i will detail some steps about how to create a KPI.

In PerformancePoint Services in Microsoft SharePoint Server 2010, a key performance indicator (KPI) is a scorecard element that shows at a glance whether performance is on- or off-target for a particular metric. KPIs can vary greatly in their appearance and complexity, but KPIs typically calculate how actual values compare to target values and indicate performance by using a graphical indicator.A PerformancePoint scorecard can include one or more KPIs.

There are two ways to create a KPI –

Import a KPI -
When you import a KPI, you use the Create a Scorecard wizard in Dashboard Designer. The wizard enables you to copy one or more KPIs from the database server into Dashboard Designer and then configure those KPIs. Select this method when you are creating a scorecard by using the wizard or when you want to import existing KPIs from a data source.
Create a KPI – When you create a KPI, you use the Create a KPI wizard in Dashboard Designer. Select this method when you want to create a KPI separate from creating a scorecard or when you want to create and configure a new KPI that you define.

To import a KPI by using the Create a Scorecard wizard -

1. In Dashboard Designer, in the Workspace Browser, click PerformancePoint Content.

2. In the ribbon, click the Create tab.

3. In the ribbon, in the Dashboard Items group, click Scorecard. The Select a Scorecard Template dialog box opens.

4. In the Category pane, click All. Then, in the Template pane, click one of the following templates:
* Analysis Services
* Excel Services
* Excel Workbook
* SharePoint List
* SQL Server Table
The template that you select corresponds to the kind of data source that you plan to use for the scorecard. For example, if you want to import a KPI that is stored in an Analysis Services database, select the Analysis Services template. After you have selected the template that you want to use, click OK.

5. In the Select a data source page, review the list of data sources on the SharePoint Site and Workspace tabs. Select the data source that you want to use, and then click Next.

6. If you selected the Analysis Services scorecard template, the Select a KPI Source page opens. (Otherwise, proceed to step 7.)
Select the Create KPIs from SQL Server Analysis Services measures option, and then click Next.

7. In the Select KPIs to Import page, select the KPI (or KPIs) that you want to use by following these steps:
Click Add KPI. A KPI from the data source that you selected for the scorecard appears. Continue clicking Add KPI until you see the KPI (or KPIs) that you want to use. To remove any KPIs from the list, select a KPI and then click Delete Selected KPIs.Click Next.

8. On the Add Measure Filters page, click Next.

9. On the Add Member Columns page, click Next.

10. On the Locations page, confirm that the correct location is specified in the Create KPIs in list, and then click Finish.

To create a KPI by using the Create a KPI wizard -

1. In Dashboard Designer, in the Workspace Browser, click PerformancePoint Content.
2. In the ribbon, click the Create tab.
3. In the ribbon, in the Dashboard Items group, click KPI.
4. The Select a KPI Template dialog box opens.
5. In the Template pane, select either the Blank KPI or Objective template, and then click OK.
* Select Blank KPI to create a single KPI.
* Select Objective to create a KPI that serves as a heading for a group of other KPIs.
The KPI that you have created opens for editing in the workspace where you can configure it.

Speak Your Mind

*