OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard Prompt
Summary
OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptContent
Hi,
I have a scenario where I need to add 2 dates on to the dashboard prompt , one is Effective Start Date and another is Effective End Date.
In the dashboard I have 3 analysis. In first analysis I need to capture these dates and compare with it like enterprise hire date is in between the dates. In second analysis, I have to compare if termination date is in between the 2 dates. In third analysis, I have to compare if assignment start date of the employee is between effective start date and effective end date.