Reminder

All Sessions are Recorded and saved to the OneDrive location listed above.

Cognos Joins & Unions

Joins: When you take two tables that are related by at least 1 field (the key) and connect them based on that key so that the tables line up horizontally. The end result is a single table with more columns than the original table.

There are different types of joins.

Unions: When you take two tables that are aligned in columns (same number of columns, same data type in the matching column) and combine them so that they are stacked on top of each other. The end result is a single table with more rows but the same number of columns.

Note: You can stack more than 2 tables in a union at a time.

When do I just a join vs a union?

Do I want more columns or more rows in the end result?

Do I have matching column (or can I create them)?

Do I have a key (or can I create it)?

Unions Use Case: Cognos DEV > Team Content > Samples > Reports > Standard reports > Cognos Multi-Query Unions for Burn Down

Cognos FP3

Successfully applied Friday 5/24 with no issues.