Oracle Transactional Business Intelligence
duplicay coming for each employee due to each employee have showing multiple mangers
Summary:
Hi Team,
In below screen shot we have taken employee name and manger name, but same employee has two line mangers coming that is the issue facing in the report.
Coming Hossen have showing two mangers but in ui is showing line manager as Ervi
How can we sort the duplicate issue?
We are using two subject areas: worker assignment real time and documents of real time
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
any help me on duplicay issue
-
any one help me on this
-
Hi Ajay,
Is there any active manager flag? I do not have access to a Fusion HCM instance, so unable to check for myself.
-
actually i miss the filter assigement status type is active so inactive also coming
answer: assigement status type = active
-
Hi Ajay,
Even after applying the filter the inactive records are coming? Is that the case?
-
no, only active coming,
-
Could you please share the XML of the report you have created.
-
Hi Ajay,
Could you add this column and check if it indicates the record which matches the manager on the UI -
"Worker"."Primary Assignment Flag"
Attaching a sample report i created.
-
Hi Ajay,
Did this work for you?
-
how can i use xml file actually i'm to xml way to create report
-
Hi Ajay,
Create new analysis, from any subject area. Then go to the Advanced tab, copy paste the xml into the section on top, then click on Apply XML. You can then save and go to the results tab to view data.
