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.