Including information about scenario overrides

As of aPriori Professional Release 2018 R1, you can now include information about scenario overrides in your spreadsheet reports. (For information about overrides, see Overriding computed values in Chapter 5.)

To do this, you must:

• Extend the scope of the data included in the report to include override data.

• Format the data as desired.

1 Add the following commands to the report’s XML file to include the user override data and specify the worksheet where data will be output.

generateUserOverrides="true"

overridesSheetName="<sheet name>"

2 Modify the report’s Excel template file to format and display the override information as desired. The override outputs will be generated in a standard format that can easily be processed using a pivot table (see the next section) to simplify formatting.

Note: This capability is currently available only for custom spreadsheet reports.The standard spreadsheet reports that are included in the out-of-the-box aPriori installation have not been updated to include override data..