Importing SSAS 2005 KPIs into the Dashboard Designer


When using the Scorecard wizard from within the dashboard designer, one of the options is to import SQL Server Analysis Services KPIs, as shown in the below screenshot.

ImportKPIs1

In order to use this import functionality, the PerformancePoint Server Web Service must reside on a server that also has the Microsoft.AnalysisServices.dll installed – which gets installed with SQL Server Analysis Services 2005. If this DLL exists on the same server as the PerformancePoint Web Service, then the dashboard designer can import KPIs from any SQL Server Analysis Services server, not just the Analysis Server that resides on the PerformancePoint server.

Without the DLL on the PerformancePoint Server Web Service machine, you will be unable to import KPIs from any Analysis Services server.

 

Alyson Powell Erwin (alysonp@microsoft.com)


Comments (3)

  1. When using the Scorecard wizard from within the dashboard designer, one of the options is to import SQL

  2. themorg31 says:

    One way to get this DLL installed is to run the SQL Server Install on your PerformancePoint server.  When you get to the "Components to Install" screen, select only the option "Workstation components, Books Online and development tools".  That should give you a minimal install, but still give you the needed components.