Fetch Manager Nation Identifier/SSN on OTBI
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):
Tagged:
0
Answers
-
One option I can see it working is to make use of Logical SQL.
Thanks.
0 -
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.
0 -
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.
0