duplicay coming for each employee due to each employee have showing multiple mangers

Amrita Gupta-Oracle

emp_mgr.zip

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.

Amrita Gupta-Oracle

Hi Ajay,

Did this work for you?

AjayKumar Maddipati

how can i use xml file actually i'm to xml way to create report

Amrita Gupta-Oracle

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.