Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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