Transaction Options dialog box

The Transaction Options dialog box is displayed when you select to insert Transaction Services into a Freeform SQL report. You have the following options:

• Insert only distinct records: Determines whether all records of the table that is updated by the transaction are inserted. By default, this check box is cleared and all records are inserted when a transaction triggers an update. This behavior is intended for using Transaction Services to update fact tables that store fact data such as revenue and profit.

  If you select this check box, only distinct records are inserted. This behavior is intended for using Transaction Services to update lookup tables that store attribute information such as customer information.

For steps to create a Transaction Services report, see the Advanced Reporting Help.