Scorecards 2.0 - Reporting on Scorecard Measure Groups

I’ve not successfully figured this out either, though I haven’t spent much time on it.

Within the Unified Scorecard Fact, the Measure Name and Measure Group Name are flat within the same object lookup: Scorecard Measures.  In my example, those three measures with the arrows roll up to Product Insights - but they’re “peers” in the same table. 

Maybe someone smarter than me can figure out how to pull those togehter using Data Designer… perhaps with a case expression… but doesn’t seem to be a native way.

I thought the Scorecard Mass Edit report used to display the group header above the individual measures at some point in the past - doesn’t look like that is the case anymore either unless I’m missing a setting someplace:

Sorry I don’t have a better answer.

@darkknight I’ve been messing with it for about 2 hours off and on, and still haven’t figured out where they are stored in the data as a roll up.   Ideally, it would be under Scorecard Measures, and there’d be a field called Group Name that I could be selected as a filter.  I’ll keep you posted if I find anything! 

@heather_hansen  completely agree!

I’m not aware of anything else than what @darkknight pointed out above in the Unified Scorecard Fact object. Because these are all the same level, I don’t think there is an easy way to nest the measures under each group using this object.  If nothing else, I 3rd your opinion that this should be easier. 

@heather_hansen @jean.nairon @darkknight We are unable to nest them, since unified scorecard fact contains data from multiple scorecards, and group definitions could be different of each scorecard. This is why we show a flat list.

@shantan_reddy measures could also be different on each scorecard, yet you were able to make that work.   Can you not take a similar approach with groups?

That’s a great solution @heather_hansen!

@darkknight There does not seem to be any way to handle all possible cases.