If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need help with JOIN

Started by Tsunami, 01 Mar 2011 02:34:12 PM

Previous topic - Next topic

Tsunami

I've got a query subject that lists personnel names and their ID numbers.
Personnel
Personnel ID
Personnel Name

I've also got query subject that has multiple types of personnel for approving purchases:

Approval Process
Approver 1 ID
Approver 2 ID
Approver 3 ID

Currently, the approver ID = Personnel ID, however when I try to join them together, I always create a cross join.  The overall goal is to replace the Approver ID with Personnel Name.

There is a currently a report that lists the various approvers for a particular purchase but it only shows the approver ID, when I actually need the approvers name.

Any ideas?

Steve

I presume you need each Approver's name from the Personel table ? if so, do this:

1> Create 2 alias shortcuts of Approver Query subject.
2> Join the original Approver Query subject to personnel with Approver 1 ID= Peronnel ID
3> Join the 1st shortcut to Personnel with Approver 2 ID= Peronnel ID
4> Join the 2nd shortcut to Personnel with Approver 3 ID= Peronnel ID
5> Create a Model Query subject and include Approver 1 ID, Peronnel Name (Name if appropirately to reflect name of Aprrover1 ID, Approver 2 ID, Peronnel Name (Name if appropirately to reflect name of Aprrover2 ID, Approver 3 ID, Peronnel Name (Name if appropirately to reflect name of Aprrover3 ID

Hope it helps

Tsunami

Thanks Steve, that helps a lot.  I didn't understand at first but after playing around with it for a bit, I ended up with what you advised and THEN I understood your post.  ;D