Converting Object ID's to Names

building semantic layer
1

I have attached a screen shot regarding my question.

There are 2 columns in one table, Approver Signature and Alternative Signature. Though both are coded as “C” they contain ID’s.

The User wants to see Objects with the names rather than ID’s.

The CTM_People_Lookup table contains the names in the full line column.

I’ve joined the 2 tables. However, am confused how a single “full name” column can return distinct values for either Appover or Alternative approver.

Can someone guide me on whether the joins appear correct? Do I need to modify the Select Statment on the Approver name? If so, how?

Thank you for your help.

:nonod:
BOB.doc (259.0 KB)

Report Writer :us: (BOB member since 2002-09-25)

2

Hi,

You need to create an alias of the CTM_People_Lookup table.

The original lookup table will be joined to the main table to its Approver Signature column and the aliased lookup table will be joined to the Alternative Signature column.

Marek Chladny :slovakia: (BOB member since 2003-11-27)