OTBI Filter Criteria
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'
Tagged:
0