Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Fetch Manager Nation Identifier/SSN on OTBI
Vibha Pandey - Oracle
Rank 3 - Community Apprentice
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