Department Tree - Father and two Child Levels of a Department in input

Content

Hello everyone,

I'm trying to create a OTBI Report to extract Father and two Child Levels of a Department given in input.
Extracting the Father of a Department is easy (with a CASE statement), but I can't find a way to pull Children of that Department.

Do you know a way to "go down" through Department Tree from a Department?

Thank you,
Giorgio