Cognos 10 – Show Chart value

1. Choose show value

   

2. Tweak the setting

   

3. For the collision mode, you guys can choose

   Fine Stagger (won’t be any overlap)

   Coarse Stagger (little overlap)

   

4. Done

Advertisement

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.