Cognos 10 – Using join

1. Pull the join icon

   

2. Pull the to be joined query to the two empty join box

   

3. Double click join icon

   

4. Make a line on the data that contain the same data (the column / dimension that connect em), and set the cardinality

   Hint : For cardinality, you guys can read the hint on the bottom part of the box

   

   

5. Click OK. Double click on the joined query.

   

6. Choose the included data item

   

7. Done

Advertisement