Fetch Manager Nation Identifier/SSN on OTBI

Vibha Pandey - Oracle

Summary: We need the Managers SSN on OTBI

Content (required): None of the OTBI Subject Areas have Manager SSN/National Identifier. How do we get it on any of the Employee manager reports.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

MandeepGupta

One option I can see it working is to make use of Logical SQL.

Thanks.

Vibha Pandey - Oracle

Hi Mandeep,

Logical SQL is again using Subject Areas (SAs) right. If there is no SA with Manager SSN how do we go about getting the Manager SSN using Logical SQL.

MandeepGupta

Vibha Pandey ,

Ultimately Manager is a Person, so if you join Manager Person Number with Person Real Time.Person Number , you can get NID from Person real time SA.

Thanks.