Dynamic Date Prompts and SQL Setup for OTBI Workforce Report

Summary:

Assistance needed with creating a dynamic OTBI report that allows users to enter date ranges for Assignment Details Effective Start Date and Assignment Details Effective End Date. The goal is for users to filter employees who were active, hired, or terminated within a selected date range.

Content (please ensure you mask any confidential information):

I’m building an OTBI report in Oracle and want to make it dynamic using prompts for start and end dates. For example, users should be able to identify employees who were:

• Active for the entire selected period
• Hired during the selected period
• Terminated during the selected period