Editing or Modifying an Aggregation Table

CAUTION:

Do not define a new staged table and use it as the source of an existing aggregation transformation.

To do so changes the metadata identity of the columns of the source table so that the aggregation transformation cannot process the source table correctly. If new columns were added to the staged table, you might want them to be included in an associated aggregation table. In that case, modify that aggregation table by using the Edit function for that table.

Use the Edit function to add or delete a computed column. (The New and Delete buttons are not available on the Specify computed columns page of the wizard when the aggregation table is being created.)

If you need to modify an aggregation table, for best results do so from within the aggregation job. (If you want to edit an aggregation table that was created by the Simple Aggregation Table wizard, the Summarized Aggregation Table wizard, or the Aggregation through Template wizard, you must first save the job that created that aggregation table.) To modify a simple or a summarized aggregation table, perform the following steps:

Locate the Aggregation transformation that generates the aggregation table that you want to modify. 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.
Right-click the aggregation table that you want to modify.

Aggregation Table Properties

From the list of properties that is displayed, select Edit.

Note: If the aggregation table is not associated with an Aggregation transformation, then the Edit option is not available.
Use the Jump to Page option to go directly to the page of the aggregation wizard that you want to change. Use the drop-down list to display the pages to which you can go directly.

Jump to Percent Change Page for a Summarized Aggregation Table
Select the page that contains the specifications that you want to modify and click Next.
Modify the contents of the page that you selected. (For information about which fields can be changed, follow the instructions that apply to the creation of the type of table that you want to modify.)
- For information about creating summarized aggregation tables, see Creating Aggregation Tables with the Summarized Aggregation Table Wizard.
- For information about creating simple aggregation tables, see Creating an Aggregation Table with the Simple Aggregation Table Wizard.
Note: If you try to delete a column that is used to create a statistic, percentile, percent change, moving statistic, rank, or join column, a warning message appears. The message lists the column, where it is used, and its table name. If a column was deleted using the Columns tab of the Properties dialog box, then the next time the aggregation wizard is opened on that table, a message appears that identifies any columns whose source column is no longer available. Click Yes to delete the columns from the table and continue to edit the table. Click No to keep the columns. In that case, the wizard does not open.
Click through the remaining pages of the wizard until the summary page appears.
Click Finish to save your changes and return to the process flow diagram.

In order for your changes take effect, you must redeploy the job. For information about redeploying jobs, see Redeploy All Jobs on the Server.