Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Salary Basis Join

Question
2
Views
0
Comments
Amh2922
Amh2922 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

I am building a OTBI report that requires the 'Benefits - Enrollment Real Time' and the 'Compensation - Salary Details Real Time' subject areas.

I need to include 'Salary Basis' from the 'Compensation - Salary Details Real Time' subject area. The only place this is available is 'Compensation - Salary Details Real Time' > 'Salary Basis - Legacy' > 'Salary Basis' > 'Salary Basis'. When I add this field to my report, the Plan Type Name, Plan Name and Option Name from the 'Benefits - Enrollment Real Time' Subject Area no longer populate results.

How do I include Benefit data & Salary data in the same report?