How to create this report?

Hi

We have table in which employee, his/her manager(who is also
has employee record in same table) and employee location information is stored.

How can i create report to get employees whose managers are in a different location?

Thanks in advance.

Regards
KRG


krgodbole (BOB member since 2003-02-24)

Is there a problem with using a conditon like employee location != manager location. Am I missing something?


jswoboda :us: (BOB member since 2002-06-20)

Hi

Thanks for reply

Is there a problem with using a conditon like employee location != manager location. Am I missing something?

I need to use same condition but data is stored like and have
objects for same. But there is no object called manager location.

Empl No. Empl Manager No. Empl Location Name
111111 2222222 JP
222222 3333333 US

how you can create this condition in report?

Regards
KRG


krgodbole (BOB member since 2003-02-24)

Idea and sketch:
If employee and manager information is stored in the same database table you might have to ask your universe designer to alias that table and provide universe objects for employee information and another set of universe objects to provide manager information.


Andreas :de: (BOB member since 2002-06-20)

Andreas’ guidance is correct. If one table is going to play multiple roles, creating an alias is the accepted approach in BusObj. Another option, if you are using Oracle at least, is the CONNECT BY PRIOR functionality. It’s a very quick way to follow a “self-referencing” chain all the way up the hierarchy.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)