Sum Measurements from peers

[PerforsN]

Hi,

I'm looking to sum the measurement for positions that have the same manager, to calculate a team total.

[former_member127775 · Accepted solution]

I have always handled this by rolling related measurements via the Reporting relationship to the manager for the total. Then created a rolldown relationship between all managers and their subordinates and rolled the total back down to the subordinates through related measurements via the Rolldown relationship. Of course, this requires keeping the rolldown relationships up to date either manually or with a DI process. Since it was used quite frequently for a prior client, we had a DI process create a rolldown relationship between the manager and subordinate when an OGPO file was dropped. I suppose the "rolldown" could also be accomplished with a plugin query that pulled the total from the subordiniate's manager for a specific measurement name but that would require someone with better sql skills than me to create.

[PerforsN]

I have submitted this as an improvement request

[PerforsN]

Thanks Melanie, I'll discuss the plugin query with my managed service team. The roll-up-down method is very maintenance dependent but is also the one I first had in mind.

It did strike me as strange though, seeing as there is a ranking function that needs the same data to calculate the rank, it just doesn't provide the used sum as an output.