OTBI Dashboard Prompt: How to "Display" one meaning to User, but Presentation Variable has another m
Summary
OTBI Complex Prompt is used to filter the type of data within report, but user needs simple list to pick fromContent
Hello All,
I have an OTBI requirement to display the dashboard prompt (screen shot attached) with Current, 30 Days, 60 Days, 90 Days & Expired. The actual data I require to be passed or extracted from those meanings are:
'Expired' --> "- Licenses and Certifications"."Expiration Date" < (current_date)
'60 Days' --> "- Licenses and Certifications"."Expiration Date" BETWEEN current_date+31 AND current_date+60
'30 Days' --> "- Licenses and Certifications"."Expiration Date" BETWEEN current_date AND current_date+30
'90 Days' --> "- Licenses and Certifications"."Expiration Date" BETWEEN current_date+61 AND current_date+90
Tagged:
0