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?