Deriving IS Manager column in OTBI

Summary

Deriving IS Manager column in OTBI

Content

Hi ALL,

I'm building OTBI Report. And I want to derive column "IS MANAGER" ( Note we are not maintaining in WorkerAssignment Detail => Manager Flag) based on Line Manager

Report should be like this.

 

Emp. Name	Line Manager Name	Is Manager
Sam P	Joe Z	N
Joe z	Anna Y	Y

Anna Y

Peter x

Y

Can some one guide.

Thanks