Skip to Content
avatar image
Former Member

Get manager's details along with candidate in BO webi

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 25, 2016 at 03:55 PM

    try this.

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2016 at 04:12 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2016 at 08:09 AM

    any idea team how to achieve this?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member AMIT KUMAR

      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