Creating DeepSee Dashboards
Adding Scorecard Widgets
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

This chapter how to add scorecard widgets to a dashboard. This chapter discusses the following topics:

Overview of Scorecards
A scorecard widget displays a set of rows like the following:
You configure the columns of the scorecard, which can be the following:
In any case, you select the items to use as columns of the scorecard, and you specify the order of the columns.
For information on creating pivot tables, see Using the DeepSee Analyzer. For information on creating KPIs and worksheets, see the DeepSee Implementation Guide. For information on creating Ensemble business metrics, see Developing Ensemble Productions.
One-Measure Pivot Tables in Scorecards
Note that if you create a pivot table that displays only one measure, you must create that pivot table in a specific way if you want to display that pivot table in a scorecard. Specifically, drag and drop the measure to the Columns box in the Analyzer, rather than the Measures box.
Rows Columns Measures Comments
Anything One measure Nothing This pivot table can be displayed in a scorecard.
Anything Nothing One measure This pivot table cannot be displayed in a scorecard. In this case, the measure is used as an MDX filter and cannot be configured as a property of the scorecard.
Adding a Scorecard Widget
To add a scorecard widget:
  1. Click ScoreCard.
  2. Click either Regular or Big.
  3. For Data source, do one of the following:
  4. Optionally specify the basic settings, as described in Adding a Widget to a Dashboard,” earlier in this book.
  5. Click OK.
  6. Optionally enable or disable the Mini Analyzer. For this, access to the Widget Settings menu and use the Analyzer option. This option controls whether this widget displays the Mini Analyzer button.
    This option is supported only when the data source is a pivot table.
  7. Add at least one scorecard column, as described in the next section.
  8. Optionally configure the widget further as described in the rest of this chapter.
  9. Optionally add controls, as described in the chapter Adding Widget Controls.”
Specifying Widget Settings for a Scorecard
For a scorecard, the Widget Settings menu has the following options:
Note:
These options add a button to the toolbar. If you use these options, be sure the toolbar is visible (its display is controlled via the Toolbar option in Settings). See Reconfiguring a Widget,” earlier in this book.
Adding Columns
A scorecard does not display any data until you add columns. A scorecard column is typically based on a property of the data source. In some cases, though, a scorecard column simply displays the item name or number and does not use a property of the data source.
To add a column to a scorecard:
  1. Access the Dashboard Editor and select the widget as described in Reconfiguring a Widget.”
  2. Click Scorecard.
  3. Click Columns.
    The system displays a list of any columns defined for this scorecard. For example:
  4. Click the plus sign + button.
    The system displays a dialog box where you specify the column.
  5. For Value, select a property of the data source, type a numeric constant, or type a formula.
    For information on formulas, see Specifying a Scorecard Formula,” later in this chapter.
  6. Optionally specify the following additional items:
  7. Click OK.
  8. Configure the column as described in the rest of this chapter.
For information on deleting and rearranging columns, see Managing Widget Properties,” earlier in this book.
Configuring a Scorecard Column
To configure a scorecard column:
  1. Access the Dashboard Editor and select the widget as described in Reconfiguring a Widget.”
  2. Click Scorecard.
  3. Click Columns.
    The system displays a list of any columns defined for this scorecard.
  4. Select the column to configure.
  5. Specify options as described after this list.
  6. Save the dashboard.
The Display option controls most of the other choices for a property. For Display, you can choose one of the following:
Display Option Sample See
Item Number Adding a Column of Row Numbers
Label Adding a Column of Row Labels
Value Adding a Column of Values
Arrow Adding Arrows
Lamp or Adding Lamps
Trend Line Adding Trend Lines and Trend Bars
Trend Bar
Plot Box Adding Plot Boxes
Hidden Not applicable; this property is not visible.  
The other options are as follows:
Specifying a Scorecard Formula
You can use formulas in the Value and Target Value options for a scorecard column. The rules are as follows:
You can use formulas in the following locations as well:
Configuring a Column of Row Numbers
A scorecard can include a column of row numbers, typically as the first column. The following shows an example:
To create such a column, add a column and configure it with the following options:
Configuring a Column of Row Labels
A scorecard can include a column of row labels, typically as the first or second column. The following shows an example:
To create such a column, add a column and configure it with the following options:
Configuring a Column of Values
A typical scorecard includes columns that display numeric values, as in the following example:
To create such a column, add a column and configure it with the following options:
You use Value Column only when you configure custom actions that require row values. See Specifying the Value of a Row,” later in this book.
Configuring Trend Lines and Trend Bars
A scorecard column can display trend lines or trend bars. The following shows an example of trend lines:
The following shows an example of trend bars:
To create such a column, add a column and configure it with the following options:
Tip:
You can display trend lines and trend bars only for KPIs, because only KPIs can contain a column of comma-separated values. In an MDX-based KPI, you can use the %LIST function to build a comma-separated list.
Configuring Plot Boxes
A scorecard column can display plot boxes, as in the following example:
To create such a column, add a column and configure it with the following options:
Configuring Arrows
A scorecard column can display triangular arrows, shown in the following example:
Arrows provide a quick way to see where the given value falls, in a desired range. They work as follows:
To create such a column, add a column and configure it with the following options:
Configuring Lamps
A scorecard column can display round lamps, shown in the following example:
Lamps provide a quick way to see where the given value falls, in a desired range. They work as follows:
To create such a column, add a column and configure it with the following options:
Customizing the Appearance of a Scorecard Widget
DeepSee provides a rich set of options that you can use to customize the appearance of a scorecard widget. To access these options, access the Dashboard Editor, select the widget as described in Reconfiguring a Widget and then see the options in the Scorecard section.
The following subsections provide details.
Note:
The easiest way to systematically alter the appearance of dashboards is to define and use themes, which are discussed in Defining and Using Themes. Themes use many of the options described in the following subsections.
Size & Appearance Options
To customize the overall size and appearance of a scorecard, access the Dashboard Editor, select the widget as described in Reconfiguring a Widget,” click Scorecard > Size & Appearance, and use the options listed there. The following options are available:
Title Options
To customize the titles in a scorecard, access the Dashboard Editor, select the widget as described in Reconfiguring a Widget,” click Scorecard > Titles, and use the options listed there. The following options are available:
Charts have a similar set of options; for examples, see Titles and Labels,” earlier in this book.
Colors & Style Options
To customize the colors and line styles in a scorecard, access the Dashboard Editor, select the widget as described in Reconfiguring a Widget,” click Scorecard > Colors & Style, and use the options listed there. The following options are available: