How to filter the employees basing on their Grade in a BIP Report

Summary:

How to filter the employees basing on their Grade in a BIP Report

Content (please ensure you mask any confidential information):

Hi,

we created a BI Report. Among the pieces of information included in our report, we entered the Grade. We would like to exclude, from the results, the pieces of information related to the employees who have some specific values associated with their grade. In order to do that, we used this sql query:

SELECT

….

FROM per_assignment_secured_list_v asg

LEFT JOIN PER_GRADES_F_VL GRADE ON GRADE.GRADE_ID=ASG.GRADE_ID

WHERE GRADE.NAME NOT IN ('24','25')