BSC Designer - Introduction
BSC Designer Manual
Product overview
Building scorecards
Adding categories and indicators
Changing indicator details
Indicator and category formula
Ignoring indicators
Balancing trees
Custom measure units
Building custom formulas
Indicator update interval
Key Risk Indicators
Strategy maps
Strategy map with KPI
Print strategy map
Mission and vision
Business Goals
External values
Project check in/out
Linking to external scorecards
SQL-powered indicators
Link KPI to certain Excel cell
Data source in XML or JSON formats
Import Values
Export Values
Edit Values
Scorecard reports
Excel reports
HTML reports
HTML overview reports
Dashboard reports
PowerPoint reports
Progress and Performance
Time points
Diagrams and charts
Adding comment to a diagram
Grouping data by time periods
Indicator Analysis
Initiatives and Attachments
Alerts and notifications
Project properties
Command line
Technical support
Common questions
AKS technical support

BSC Designer - Online Manual

Prev Page Next Page

Command Line to Create Balanced Scorecards in Excel


Introduction - Functions Overview - Purchase Program

Using command line interface with Balanced Scorecard Designer

A command line interface is available in BSC Designer. Using the command line interface, you can generate Excel reports in silent mode. This is very useful when you need to integrate BSC Designer with another business application.

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

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

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

When using long paths to the files, be sure to use quotation marks, as in "C:\program files\BSC Designer\..."

Time points in reports

Starting with version 1.4, Balanced Scorecard Designer supports time points. If you are using time points and need to get a report for a certain date, use the "-date" parameter + date as it is according to your current computer 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, depending on your configuration)

HTML report via command line

It is possible to generate HTML reports through the command line interface. For that function you should specify the starting and ending date for the report and add the -html option in the command line

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

Other reports:

  • the -overview option in a report will enable generation of overview reports, for example: bsc_designer.exe some_project.bsc -html -export report.html -overwrite -overview
  • the -powerpoint option will generate a report in PowerPoint presentation (.ppt) format, for example: bsc_designer.exe some_project.bsc -powerpoint -export report.ppt -overwrite

Exporting strategy maps

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

Command line syntax:

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

Sample: export of an existing map.

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

Sample: export of a map as a snowflake.

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

Sample: create a report that includes all supported strategy maps

  • bsc_designer.exe some_project.bsc -export C:\report.html -allmaps
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)