Get manager's details along with candidate in BO webi

[Former Member]

Hi All,

My data in a report is like this

id name city manager'sId mgrName mgrCity

I only have one city column and have to dynamically get manager;s city data
i have the data but how to display it?
i tried using foreach "=[Work City] Where ([ID]=[ManageID]Foreach([ID]))"

but it doesn't work,
not able to recollect what i did earlier!!!! 😞
any idea guys

[Former Member]

any idea team how to achieve this?

[amitrathi239]

can you share some sample data plz.

[Former Member]

Hi Amit,

Sample data is

id name city mgrId

1 abc mumbai 5

5 def delhi 6

6 xyz london 8

so that's the data

and i want my result as

id name city mgrId mgrcity

1 abc mumbai 5 delhi

5 def delhi 6 london

so basically want the employees manager on the same row as a separate column

[Former Member]

the data is in such a way that for a particular row, and id, his managerid will be in the same row and also in a separate row where the manager is an employee,

since we are comparing id=manageid so is it evaluating it at individual row or scanning whole row?

[amitrathi239]

try this.

=[Work City] Where ([ID]=[ManageID] IN ([ID]))

[Former Member]

Hi Amit,

It's showing as blank , tried your approach