OTBI Added formula column and filter stopped working — 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 Added formula column and filter stopped working

edited Mar 12, 2025 7:50PM in Reporting and Analytics for HCM 4 comments

Summary:

I added a column from the Subject Area Recruiting - Recruiting Events Real Time of:

CASE WHEN "Recruiting - Recruiting Events Real Time"."Job Requisition History - Event Details"."Phase Code" = 'REQUISITION_POSTING' THEN "Recruiting - Recruiting Events Real Time"."Job Requisition History - Event Details"."Event Date" ELSE NULL END

But now it is ignoring my filter from the Subject Area

Recruiting - Recruiting Events Real Time

of:

"Job Application - Progression"."Current Phase" is equal to/is in HR

How do I fix that?

I also tried:

CASE WHEN "Recruiting - Recruiting Events Real Time"."Job Requisition History - Event Details"."Phase Code" = 'REQUISITION_POSTING' AND "Recruiting - Recruiting Events Real Time"."Job Application - Progression"."Current Phase" = 'HR' THEN "Recruiting - Recruiting Events Real Time"."Job Requisition History - Event Details"."Event Date" ELSE NULL END

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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