BusinessObjects Board

Lookup in same table

building reports webintelligence
#1

In my data source I have three columns available (Employee Name, Employee Email, and Supervisor Name).

What I am trying to do is simply create a new column with Supervisor Email. Since every employee is listed the supervisors email would just need to be found from the Employee Email, but no clue where to start with SAP.

#2

If you have access to the universe, I would recommend making an alias of your table (call it Supervisor). You can then join from the first table.Supervisor Name to the alias (Supervisor) Supervisor Name. The email from the alias table will be your Supervisor email.