Oracle Transactional Business Intelligence

when i taken manger number and name from manager folder then company level coming mulitiple number
Summary:
Hi Team,
when i taken manger number and name from manager folder then company level coming mulitiple numbers for each mangers .
How can i rectify the issue.
PFA
THanks,
Ajay
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Can you please share the report and the subject area that you are using ?
-
Hi Ajay,
Please share the xml for the report you have built. Also, try applying MAX function on the Company Level. It will then return the latest level, and, result in a single row.
-
Please find and xml file . issue is we have company level(DFF) from job folder but its not taking company level of manger .
requirment is we need levels of line manager report
Thanks,
Ajay
-
I'm using workforce managment assisgnemt real time
-
actually its taking employee company level but we need manager company level and alos we have only one company level in job folder
-
Please provide us the nqquery.log file of the report
-