Oracle Transactional Business Intelligence

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

How can we show only Active assignments for Active employees

Received Response
23
Views
1
Comments
Ruchi Shivhare
Ruchi Shivhare Rank 2 - Community Beginner

We have an Analysis Report that lists Registrations for employees. We want all active, suspended and terminated employees show up here. However, business wants to see only active assignments in case an Active employee has inactive assignments too.

Tagged:

Answers