Cognos 10 – Using Union, intersect, except

  1. Drag union

  2. Drag queries into places

  3. Double click the union query

  4. Pick which one will be included in our final query

  5. Done
  6. You can use this technique for except and intersect too.

They operate by join the appropriate row. So Query 1 first row data item will be unioned / intersected / excepted with data item on Query 2 first row data item, and so on.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s