Employee Hierarchy: Total for Manager includes self

Question

Hello, Experts!

We are running on OAC 12.2.5.2.0, and I have a custom, level-based, ragged employee hierarchy that I am otherwise happy with. The issue is that the totals at each level include the parent of the level; e.g., in the example below, the headcount for Bossy Person should be 6, not 7. The issue isn't "cumulative"; i.e., when I get to the very top of the hierarchy, the total is only one higher than reality. Anybody encounter similar and/or have any suggestions, please?

Here's the dimension config in the .rpd. "MGR_NAMEn" isn't necessarily a manager, as EMPLID and NAME repeat in the first empty slots.

And lastly, here's a peek at what the data look like:

Gianni Ceresa · Answer

Hi,

Honestly I believe the hierarchy is acting fairly right in counting the manager himself in the headcount of the level, at least from a logic point of view.

Does the total at each level really include the parent or just include the level itself?

Sure you could have a "dirty" approach of adding by default a " -1 " after the aggregation is done, but that's quite "dirty" (and also not always right if there isn't a manager at that level but only somewhere above).