Partilhar via

Importing SQL Server Analysis Services 2005 KPIs into Scorecards

  • Artigo

With PerformancePoint Monitoring Server you can directly import SSAS 2005 KPIs into a scorecard using the Scorecard wizard. The following steps illustrate this process:

1. Create your data source and publish to the server.

2. Right click on Scorecards and select New Scorecard.

3. Select Microsoft from the Category selection, the Analysis Services template, ensure that the Use Wizards to Create Scorecards selection is selected, and click OK.

4. Assign a name for your scorecard, optionally assign a display folder and permissions. Click Next.

5. Select your data source. Click Next.

6. Select Import SQL Server Analysis Services KPIs, click Next.

7. Select the KPIs you wish to import, click Next.

8. Optionally add measure filters, click Next. Optionally add column members, click Finish.

image

9. Notice that the formatting from the cube does not get imported into the KPI. Edit each KPI to adjust the formatting or use Bulk Edit to edit the KPIs with similar formatting.

10. Your scorecard will now look as follows:

image

11. Publish your scorecard and deploy it to Sharepoint.

If you review a KPI in the Dashboard Designer that was created by an import of an SSAS KPI, you will notice that the Data Mapping come over as Custom MDX formulas and the Banding Method is Band by Stated Score. The indicator type in SSAS 2005 should be honored once imported to the Dashboard Designer.

image

image

 

Alyson Powell Erwin (alysonp@microsoft.com)

Comments

  • Anonymous
    August 22, 2007
    NOTE: This article was written with PerformancePoint Server 2007 (CTP3). UI and features subject to change.

  • Anonymous
    September 12, 2007
    Hi Alyson, After I imported my SSAS KPIs to PPS CTP4 but my scores are not correctly working using the default migrated mode (Band by Stated Score) It shows 0% all the time. Any suggestion to fix this? I also tried to change the banding method to use the Normalized (Actual-Lower) /(Target-Lower) but this give me a score of 100% for all my values. Were can I find more information about scoring with SSAS KPIs?? Thanks a lot!

  • Anonymous
    May 26, 2008
    Hi, I have two date list filters one is for Fromdate and another is for Todate. My KPI should get the actual values from the cube for given date range(Between Fromdate and Todate).Can u show me how to create MDX tuple formula for this. Thanks in advance. Bobby.

  • Anonymous
    January 26, 2009
    There are two ways to create KPIs in PerformancePoint Server based on SSAS KPIs. The first is to use

  • Anonymous
    June 22, 2009
    What better place to create KPIs, PPS or SSAS? I want to edit the goals through a client application.