Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
BI Publisher data model filter manager type
Summary
Recently implemented second manager type which is causing multiple lines on BIP reportContent
We have a daily BIP report that sends employee data based on actions done. This data includes manager person number, but with the recent addition of a second manager type for hiring manager, it is sending that data in the report as well causing multiple rows. Looking at trying to filter the existing data model to only show line manager person number.
Can anyone assist with what to add to this to only return the line manager type?
MGR.PERSON_NUMBER SUPERVISOR_NUM,
WHEN to_char(ASG_MGR.LAST_UPDATE_DATE,'YYYY-MM-DD') = to_char(:SDATE,'YYYY-MM-DD') THEN
Tagged:
0