Adding columns to the Excel file

You configure the BOM to add columns to the Scenarios and Expected Results sheets.

About this task

The Excel scenario file uses information from the BOM to generate columns. The input parameters, the attributes, and the constructor arguments are used to create the input columns in the Excel scenario file template. You can also configure the BOM to add columns in the Scenarios and Expected Results sheets.

You can create attributes in the BOM to add new columns in the Scenarios sheet or in the Expected Results sheet.

Procedure

To add columns to the Scenarios and Expected Results sheets:

  1. Create virtual attributes:
    • Writable attributes (“Read/Write” or “Write Only”) for optional columns in the Scenarios sheet

    • Readable attributes (“Read/Write” or “Read Only”) for columns in the Expected Results sheet

  2. Define the BOM to XOM mapping for these virtual attributes:
    • Edit the setter part for a new column in the Scenarios sheet

    • Edit the getter part for a new column in the Expected Results sheet

  3. Select the new available Expected Results options when you generate the Excel scenario file template.

Results

To add required columns, you must modify the list of arguments of the DVS constructor, or choose a different DVS constructor.