Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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.
Analysis relational filter
Summary:
I am trying to create an OTBI analysis as a new Oracle customer.
Certain fields have multiple values. I am wanting to create one unique row per person , where the additional values are split up in columns.
For example. Multiple phone types and numbers. But I don`t want to exclude records that don`t have a value.
This seems to be more complicated than it should be in OTBI Analysis.
I created a case statement :
case when
"Workforce Management - Person Real Time"."Person Phones"."Phone Type" = 'Home Phone'
THEN
"Workforce Management - Person Real Time"."Person Phones"."Search Phone Number"
Tagged:
0