Command Line to create Balanced Scorecard in Excel

 

Introduction - Functions Overview - Purchase Program

Using command line interface

Command line interface is available is BSC Designer. Using command line interface you can generate Excel report in a silent mode. This is very useful when you need to integrate BSC Designer with some other business application.

The interface for command line is: [Filename] [-export FileName] [-overwrite]

For example, if you need to export file "Scorecard1.bsc" into Excel file "Report.xls" you should use the following parameters when run BSC Designer from third-party tool:

  • "Scorecard1.bsc" -export "Report.xls" -overwrite

When using long paths to the files, be sure you are using "" symbols, such as "C:\program files\BSC Designer\..."

Time-points in reports

Starting version 1.4. Balanced Scorecard Designer supports time points. If you are using time points and need to get report for a certain date, use the "-date" parameter + date as it is according to current computers settings, for instance:

  • "Scorecard1.bsc" -export "Report.xls" -overwrite -date 01.24.2007
  • Please, note: the date must be according to your current computer settings (it might be DD.MM.YYYY or MM.DD.YYYY, depends on your setttings)

HTML report via command line

It is possible to generate HTML report via command line interface. For that function you should specify starting and ending date for report and add -html key as a parameter

  • Example: bsc_designer.exe some_project.bsc -date1 20.12.2007 -date2 02.01.2008 -html -export report.html -overwrite

Other reports:

  • -overview key in report will enable generating of overview type report, example: bsc_designer.exe some_project.bsc -html -export report.html -overwrite -overview
  • -powerpoint key will generate report in format of PowerPoint presentation (.ppt), example: bsc_designer.exe some_project.bsc -powerpoint -export report.ppt -overwrite

Exporting Strategy Map

Starting version 3.0 Strategy Maps are supported in the BSC Designer. The strategy map can be exported using BSC Designer's interface or command line:

Syntax for command line:

  • bsc_designer.exe BSCFileName -export PictureFileName -StrategyMap [-StrategyMapPlacement <SnowFlake|HTree|Tree|Classical|Cascading|Table|Cyclical|Strategic>] [-StrategyMapLevel <MaxLevel>]
  • Check more information about StrategyMapPlacement appearance.

Sample: export of existent map.

  • bsc_designer.exe some_project.bsc -export "C:\resulted_file.jpg" -StrategyMap

Sample: export of map as a snowflake.

  • bsc_designer.exe some_project.bsc -export "C:\resulted_file.jpg" -StrategyMap -StrategyMapPlacement SnowFlake -StrategyMapLevel 1