OTBI Dashboard Prompt: How to "Display" one meaning to User, but Presentation Variable has another m — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Dashboard Prompt: How to "Display" one meaning to User, but Presentation Variable has another m

edited Oct 28, 2019 5:42PM in Reporting and Analytics for HCM 4 comments

Summary

OTBI Complex Prompt is used to filter the type of data within report, but user needs simple list to pick from

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!