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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

OTBI Custom Dashboard Prompt

edited Aug 12, 2020 11:38PM in Reporting and Analytics for HCM 7 comments

Summary

Looking for ideas on Custom Dashboard Prompt

Content

Hello,

 

We want to create a custom dashboard prompt to add to the other list of prompts. We need a prompt for VP. We are NOT currently storing VP, but our definition of VP is CEO minus 1. Is there a way to look at the parent manager column and create a CASE statement to look at each of those columns and find the VP? After it finds the VP, we will have it in a column and we want to be able to prompt users to be able to select the VP from the list.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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