Overview

In some environments it is not possible to install Dashboard Designer using the normal process (i.e. allow it to install automatically when first opened from SharePoint).  Some Citrix environments for example have permissions that prevent ClickOnce apps from being able to install. 

In these cases people sometimes look for alternative methods (e.g. using an installer / MSI).  Unfortunately, there is no MSI available for download for Dashboard Designer from Microsoft.  However, it is possible to put together an alternative method for installation.  The approach outlined below is one approach I have used in a couple of customer environments.

The process is in two parts:

  1. Gather the files to install Dashboard Designer
  2. Install Dashboard Designer

Note – This is not an officially supported way of installing Dashboard Designer, but it has worked where I have used it in the past.  If thinking of using this, you should thoroughly test it in your environment as your environment may throw up issues I haven't encountered.  Also, when updates to Dashboard Designer are released (e.g. in SharePoint Service Packs) it will be necessary to repeat this alternative installation procedure to get the updated versions deployed.

Pre-reqs

This process does not install the pre-reqs for Dashboard Designer:

  • .NET Framework 3.5 Service Pack 1
  • Microsoft® SQL Server® 2008 R2 Native Client – Download
  • Microsoft® SQL Server® 2008 R2 ADOMD.NET – Download

You should ensure these are also deployed to the target environment prior to installing Dashboard Designer.

These pre-reqs apply irrespective of whether you are installing using the normal ClickOnce method or an alternative approach (the ClickOnce installation does not install these pre-reqs).

Gather the files to install Dashboard Designer

This approach requires a machine* that you can install Dashboard Designer on in the normal way (i.e. download the Click Once app from SharePoint).  On this machine, we’ll grab a copy of the Dashboard Designer files, ready to install on another machine (i.e. where the Click Once apps don’t work).

(*This machine also needs Visual Studio or another .NET SDK on to be able to use mage.exe).

  1. On a machine with Visual Studio installed, run
    mage.exe –cc
    This clears the click once cache.  This means that after step 2, the only files in the Click Once cache are the Dashboard Designer files.
  2. Open Dashboard Designer from SharePoint (i.e. allow it to install using the normal Click Once install mechanism).
    This downloads Dashboard Designer and installs it.  The dashboard designer files are copied into the Click Once cache, where we can pick them up.
  3. Go to the Click Once cache - for my profile this is:
    C:\Users\xchrisbailiss\AppData\Local\Apps\2.0\...
  4. Copy all of the dll, exe and config files out of this directory and subdirectories (ignore all the manifests, etc). 
    The easiest way to locate the files (since they are scattered across various subdirectories) is to search and specify the wildcard character *
    A whole bunch of directories etc will be listed.  Copy the dll / exe / config files.  For those files in an En folder, copy these into an En subdirectory.
    Some files appear to be present in multiple directories on some installations.  These files have the same name, size and last modified date so are very likely just multiple copies of the same file.
  5. Check the file and folder structure against the file list below:
    1. Most of the files are in a single folder
    2. Inside this folder is a single subfolder named "En" which some of the files sit in.

File list

  • DashboardDesigner.exe
  • DashboardDesigner.exe.config
  • DashboardDesigner.resources.dll
  • Microsoft.PerformancePoint.Common.Calculation.dll
  • Microsoft.PerformancePoint.Common.Calculation.resources.dll
  • Microsoft.PerformancePoint.Scorecards.Client.dll
  • Microsoft.PerformancePoint.Scorecards.Client.resources.dll
  • Microsoft.PerformancePoint.Scorecards.Common.dll
  • Microsoft.PerformancePoint.Scorecards.Common.resources.dll
  • Microsoft.PerformancePoint.Scorecards.Designer.Framework.dll
  • Microsoft.PerformancePoint.Scorecards.Designer.Framework.resources.dll
  • Microsoft.PerformancePoint.Scorecards.DesignerPlugins.dll
  • Microsoft.PerformancePoint.Scorecards.DesignerPlugins.resources.dll
  • Microsoft.PerformancePoint.Scorecards.DesignerWorkspace.dll
  • Microsoft.PerformancePoint.Scorecards.DesignerWorkspace.resources.dll
  • Microsoft.PerformancePoint.Scorecards.WizardFramework.dll
  • Microsoft.PerformancePoint.Scorecards.WizardFramework.resources.dll
  • Microsoft.SharePoint.Client.dll
  • Microsoft.SharePoint.Client.Runtime.dll
  • En\DashboardDesigner.resources.dll
  • En\Microsoft.PerformancePoint.Common.Calculation.resources.dll
  • En\Microsoft.PerformancePoint.Scorecards.Client.resources.dll
  • En\Microsoft.PerformancePoint.Scorecards.Common.resources.dll
  • En\Microsoft.PerformancePoint.Scorecards.Designer.Framework.resources.dll
  • En\Microsoft.PerformancePoint.Scorecards.DesignerPlugins.resources.dll
  • En\Microsoft.PerformancePoint.Scorecards.DesignerWorkspace.resources.dll
  • En\Microsoft.PerformancePoint.Scorecards.WizardFramework.resources.dll

Install Dashboard Designer

We are now in a position to test the install.  Note - the files simply need to be copied to the target machine.

  1. Copy the files in this structure to the target machine.  They can be placed anywhere (example install folder structure given below).  No further activities are required – the install is as simple as copying the files.
  2. Run Dashboard Designer.
  3. Enter the SharePoint URL when prompted, e.g. http://MySharePointServer/ 

On one machine I tested this on, the Designer crashed after the SharePoint URL was first entered.  Upon reopening however, the designer was fine (and the URL had been saved correctly).  This crash appeared to only happen on the very first time Dashboard Designer was opened – subsequently it always opened without any problem.

Install Example

Dashboard Designer can be installed to any folder. 

For the purposes of this example, assuming that we are installing to
c:\Dashboard Designer

So, simply copy the above files to the following paths (no MSI is needed, no DLL registration is needed):

  • C:\DashboardDesigner\DashboardDesigner.exe
  • C:\DashboardDesigner\DashboardDesigner.exe.config
  • C:\DashboardDesigner\DashboardDesigner.resources.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Common.Calculation.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Common.Calculation.resources.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.Client.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.Client.resources.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.Common.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.Common.resources.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.Designer.Framework.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.Designer.Framework.resources.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.DesignerPlugins.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.DesignerPlugins.resources.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.DesignerWorkspace.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.DesignerWorkspace.resources.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.WizardFramework.dll
  • C:\DashboardDesigner\Microsoft.PerformancePoint.Scorecards.WizardFramework.resources.dll
  • C:\DashboardDesigner\Microsoft.SharePoint.Client.dll
  • C:\DashboardDesigner\Microsoft.SharePoint.Client.Runtime.dll
  • C:\DashboardDesigner\En\DashboardDesigner.resources.dll
  • C:\DashboardDesigner\En\Microsoft.PerformancePoint.Common.Calculation.resources.dll
  • C:\DashboardDesigner\En\Microsoft.PerformancePoint.Scorecards.Client.resources.dll
  • C:\DashboardDesigner\En\Microsoft.PerformancePoint.Scorecards.Common.resources.dll
  • C:\DashboardDesigner\En\Microsoft.PerformancePoint.Scorecards.Designer.Framework.resources.dll
  • C:\DashboardDesigner\En\Microsoft.PerformancePoint.Scorecards.DesignerPlugins.resources.dll
  • C:\DashboardDesigner\En\Microsoft.PerformancePoint.Scorecards.DesignerWorkspace.resources.dll
  • C:\DashboardDesigner\En\Microsoft.PerformancePoint.Scorecards.WizardFramework.resources.dll

A Note About the User.Config File

This process does not create the user.config file.  This will normally be created automatically the first time Dashboard Designer is run.  Again, on some environments this may not be possible and creating it as part of the installation process may be desirable. 

When Dashboard Designer is installed using this alternative approach, Dashboard Designer will create this file at the following location (where in my case [username] is xchrisbailiss):

C:\Users\[username]\AppData\Local\Microsoft_Corporation\DashboardDesigner.exe_StrongName_wl4f4koizhxra1ieka4fa0ofam43g0lh\14.0.0.0

If creating this file manually, you also probably want to set the following settings within this file:

  • “MruSiteCollection” to the SharePoint URL, e.g. http://MySharePointServer/
  • “Default Workspace Location” to the users default documents folder.