Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Creating dependent prompt in OTBI analysis
Summary
Creating dependent prompt in OTBI analysisContent
Team,
I have created a variabl 1st prompt for "Review Period" with "@{variables.ReviewPeriod}".
Now i am trying to 2nd prompt for "Performance Document name" depending on the 1st prompt.
Trying to build the below sql to work. But it is not working.
Please advise how to complete this task.
1st Prompt:
Review Period:
SELECT "Review Period"."Review Period Name" FROM "Workforce Performance - Performance Task Status Real Time"
2nd Prompt: Not working.
Performance Document Name:
SELECT "Performance Document"."Performance Document Period Name" FROM "Workforce Performance - Performance Task Status Real Time" where "Review Period"."Review Period Name" = '@{variables.ReviewPeriod}{Annual Review Period FY 2020}'
Tagged:
0