I'm using Organizational Unit (0ORGUNIT char) on a "Employee FTE count" report customer asked. As you may know, 0ORGUNIT has hierarchy. Hierarchy is working kind of well, but not 100% fine. What is happening to me is that, imagine a 4 levels hierarchy (1 top - 4 bottom), so employees who belong to level 4, they are correctly displayed on the org.unit they belong, but on the above levels too! For example, a employee who's on 2 level, he's not displayed on levels 3 or 4.
This "duplication" is happening to some of the employees, not all.
Do you know why is this happening? Is there any specification on Query Designer or on the hierarchy I have to modify?
Thanks in advance!