4.5 Excel Import Templates - Processing Templates for Variable Row Tables

After navigating to a variable row table in DPM Authority, go to Tools → Variable Row Tables to establish a connection to the table’s import template or an SQL connection.

The Nominate a Connection form lists the available connections that can be used during the Refresh Links process. The Fact List type establishes a connection to the Fact List sheet in the Excel Import Template.

TIP: Table and Sheet names can be copied to the clipboard using the button on the right-hand side of the comboboxes:

The Process Import Template form helps you process the required import template by selecting either the Tables or Fact List type during the Refresh Links process:

Delete Rows button allows clearing the current variable row table: