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

Leave a Reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s