Oracle Communities

Oracle Analytics and AI

Child Item

when i taken manger number and name from manager folder then company level coming mulitiple number

AjayKumar Maddipati

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):

Find more posts tagged with

OTBI

Customizing Reports

Report Output

Core HR

Accepted answers

All comments

Abdul Rauf Mohammad-Oracle

Can you please share the report and the subject area that you are using ?

Amrita Gupta-Oracle

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.

AjayKumar Maddipati

Hi @Amrita Gupta-Oracle

@Abdul Rauf Mohammad-Oracle ,

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

XML. manger.txt

Thanks,

Ajay

AjayKumar Maddipati

I'm using workforce managment assisgnemt real time

AjayKumar Maddipati

actually its taking employee company level but we need manager company level and alos we have only one company level in job folder

ravikiran goda-Oracle

Please provide us the nqquery.log file of the report

AjayKumar Maddipati

@ravikiran goda-Oracle ,

PFA nq query

nqquery. manger.txt