Defining the scoreboard properties

  1. Select Scoreboard > Actions > Properties for Scoreboard record.
    Note: The Scoreboard Properties dialog can also be opened by selecting a scoreboard record and right-clicking on it and then selecting the Properties option.
  2. Specify this information:
    Name
    Specify a name for the scoreboard.
    Category
    Specify a category or select an existing category from the list. It can be used to filter the Scoreboard.
    Description
    Provide a short description for the scoreboard record.
    Owner
    Select the owner of the scoreboard.
    Scope
    Select Private or Public. This defines who owns the Scoreboard and who can view it.
    Type
    Displays the Scoreboard type. Note that this is a read-only text box.
    Favorite View
    Displays the favorite view being used by the Scoreboard.
  3. Click Calculation setup and use this table to specify the properties for the scoreboard:
    Parameters Action
    Formula Select an applicable formula template from one of the available lists. Click Select.

    The calculation conditions of the selected formula are displayed in the last field of Calculation Parameters. See Formulae for Scoreboard Calculations.

    Measures Select the applicable measures to be used in the formula for scoreboard calculation. Select a measure for Mark to show cells matching the conditions for calculations for a Scoreboard.
    Limits/Factors Specify a value in the Lower and Upper fields. To exclude the upper or lower value, select the Exclusive check box.
    Bound Select Inside or Outside to specify the inner or outer limits in the scoreboard calculation.
    Note: The Exclusive check boxes are selected for both Lower and Upper limits when you select Outside bound.
    Function/Calculated Deviation (CDev) Function: Select the applicable function(s) to use them in a calculation. The functions are: Abs, Round, Truncate and Average. When Tracking Signal is selected as formula only the function Interval is available.

    Calculated Deviation (CDev): When a Forecast Alarm formula is selected this option is displayed instead. Select the appropriate setup values to be used in the Deviation calculation. The functions are: Type and Smoothing or Periods

    Periods/Mean Forecast Errors Periods: Define the offset in periods between two measures used in a formula.

    Mean Forecast Error is used to define the number of periods when Forecast Alarm 2 is selected as formula.

    # of Times Specify the number of times a calculation should evaluate "true" before a record is considered a hit. After the record is considered a hit, the score is incremented.
    Dataset(s) Select a Dataset from the available number of Datasets displayed in the list.
    Note: For Number of Phantoms, Number of Phase Out's, Number of SA awaiting acceptance and Number of unconfirmed SP's calculation setup, select a Dataset from the list.

    This option is valid for the these types of scoreboards:

    • Favorite View Key Based
    • Favorite view based
    • Number of Phantoms
    • Number of Phase Out's
    • Number of SA awaiting acceptance
    • Number of unconfirmed SPs
  4. Specify this information for the calculation time filter:

    Calculation Time filter enables the user configure the time range where the calculation is performed. Scoreboard calculation time filter is always constrained by the Favorite View Time Filter. This option is valid only for Favorite view-based scoreboards.

    Select Time Frame
    Select a Dataset from the available number of Datasets displayed in the drop-down list box. Select this to configure the time range. By default, Favorite View option is selected.
  5. Specify this information for the highlight colors:

    Highlight Colors enables the definition for the color that indicates the scoreboard calculation.  This option is valid only for Favorite view based scoreboards.

    Default Color
    The default color is used for all conditions where the calculation is true.
    Color Ranges
    Color ranges can be used for defining the colors in a specific range. The value ranges must be defined in increasing order. You can also add, update and delete the color ranges.
  6. Specify the values and settings for scoreboard.

    This option is used to configure additional settings for scoreboard calculations.

    Calculation Values
    These values are read-only fields and they display the number of occurrences for Hits, Previous Hits and Change, respectively.
    Type Icon
    Select a custom icon from the drop-down list after de-selecting the Standard checkbox. By default, the Standard checkbox is selected.
    Settings
    Define the scoreboard calculation settings:
    Null cells are considered cells with zeroes
    Select this to include null cells as cells with zero values.
    Average calculations include null cells
    Select this to include null cells for Average calculations for scoreboards. By default, null cells are not included in Average function.
    Open Scoreboard with all rows
    Select this option to display the entire Favorite view. Note that the cells meeting the calculation conditions are also marked by colored dots. By default, only the records matching the conditions for calculations for a Scoreboard are displayed.
    Ignore small divides
    Select this option to ignore small divisor values in a calculation formula. It is used when a scoreboard formula contains division. A small divisor will often yield a large result. Small divisor value is not always desired or relevant to be the cause of an exception.
    Abs (Divide) >
    Specify the value below which divisor values should be ignored, for example, 0.1. The function considers both positive and negative values.
    Show Calculation data
    Select this option to display an additional measure called Scoreboard Calculation (SBC). SBC is the calculated value used for Scoreboard comparisons during complex Scoreboard calculations.
    Column Name

    Select this option to make the name of the calculation column reflect the content of the column. Click here to see the options.

    Formula Template Default Column Name
    Forecast Percentage Accuracy Accuracy
    Forecast Percentage Error

    Forecast Percentage Accuracy

    		Error
    Forecast Error Error
    MFE - Mean Forecast Error Error
    MAD - Mean Absolute Deviation Deviation
    MAPE - Mean absolute Percentage Error Error
    MSE - Mean Squared Error Error
    RMSE - Root Mean Squared Error Error
    Accuracy Signal Signal
    Tracking Signal Signal
    Formula Default Column Name
    Change Interval  : [M(P + C(P) , M(P+n)] Change
    Forecast Alarm 1 - Demand Check CDev
    Forecast Alarm 2 - Forecast Error Check CDev
    Tracking Signal Signal

    All other Scoreboards get the column name "SBC".

    No. of decimals
    Specify the number of decimals to be used. The default value for all formulae is 2.
    Display column values as percentage
    Select this option to display column values as percentage. It is only available for the formulae where it makes sense. For all other formulae the option is hidden.
  7. Click OK to save the changes.
Related topics