Publishing an Aggregation Table as Template

To publish an aggregation table as a template, perform the following steps:
  1. Locate the Aggregation transformation that generates the aggregation table that you want to publish as a template. To do so, from the IT Data Marts tree, navigate to the IT data mart that contains the job where the Aggregation transformation is located. Double-click the job to open it on the Diagram tab of the Job Editor window.
  2. Right-click the aggregation table that you want to publish.
  3. From the drop-down list, select Publish. If you selected a summarized aggregation table, the Publish as User Defined Template - Summarized Summary Aggregation dialog box appears. If you selected a simple aggregation table, the Publish as User Defined Template - Simple Aggregation dialog box appears.
  4. The Name field contains the name of the table that you want to publish.
    (Optional) Enter a name and a description, that is more meaningful to you.
  5. In the Location field, accept the default location or click Browse. This action opens the Select a Location dialog box where you can navigate to another location. Select the location that you want to use and click OK.
    Note: The Location field must be the default location or a location that is underneath it.
  6. Click OK to create the template.
  7. Save the job.