Removing columns from the Excel file

You configure the BOM to remove columns from 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 remove columns from the Scenarios sheet.

By default, there is a column for each constructor argument and for each attribute (providing it is non-static and writable). If you do not want to display all the attributes as columns in the Scenarios sheet, you can exclude them.

Procedure

To remove optional columns from the Scenarios sheet:

  1. In the Rule Explorer, double-click the attribute that you want to exclude from the Excel scenario file.
  2. In the General Information area, select the Ignore for DVS option.

Results

This option ensures that there is no column in the Excel scenario file template for the attribute you have excluded.

To remove required columns, you can either modify the list of arguments of the DVS constructor, or choose a different DVS constructor (see Relationship between the BOM and the Excel file).