Editing the union, except, and intersect custom tables

You can add and remove tables from an existing union, except, or intersect custom table. You can also update the columns in these custom tables based on column changes in their underlying reference tables.

In previous versions of Cognos® Analytics, to make these types of changes you needed to recreate the union, except, or intersect table.

Adding and removing tables

In the data tree, the Relationships diagram, or on the Custom tables tab, from the union, except, or intersect table context menu, select the Edit table option to open the table editor.

Table editor

Then, proceed to add or remove tables from these 3 types of custom tables.

For more information, see Editing the union, except, and intersect custom tables.

Updating columns

You cannot explicitly add, remove, or modify columns in an existing union, except, or intersect custom table. However, you can do these changes in its reference tables, and then synchronize the changes.

When you add, remove, or modify columns in the reference tables, the column changes are not automatically synchronized with the custom table, and validation errors might be generated for the custom table. To apply the column changes to the custom table, select its Edit table option (in the data tree, the Relationships diagram, or on the Custom tables tab) to open the table editor.

Validation errors

Then, proceed to verify and update the custom table with the updated columns. The columns in the reference tables and the union, except, or intersect custom table are now synchronized.

For more information, see Editing the union, except, and intersect custom tables.