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 Filter Criteria

Received Response
21
Views
3
Comments
edited Dec 23, 2021 1:06PM in Reporting and Analytics for HCM 3 comments

Summary:

Need help to add a filter criteria in OTBI analysis.

I am using the below filter criteria which is working in payroll subject area:

"Balance Types"."Balance Name" LIKE '%Entitlement Hours'

or

"Balance Types"."Balance Name" IN (CASE WHEN "Balance Types"."Balance Name" LIKE '%Entitlement Hours' THEN "Balance Types"."Balance Name" ELSE NULL END)

I wanted to add one more balance name 'TBI Payslip Total Hours Worked' into this criteria which is hard corded value.

I have tried the below codes but did not work:

  • "Balance Types"."Balance Name" LIKE '%Entitlement Hours' || 'TBI Payslip Total Hours Worked'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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