Has anyone come up with a way to report on NA scorecard measures?

  • 2
  • Question
  • Updated 6 months ago
I have been speaking with a customer who has manual measures and would like to report on the measures that have not been set. As of now I have not been able to determine a way this is possible.
Photo of Michael Sweeney

Michael Sweeney, Employee

  • 2,588 Points 2k badge 2x thumb

Posted 6 months ago

  • 2
Photo of Steven Doty

Steven Doty

  • 1,192 Points 1k badge 2x thumb
Thanks for posting this, Mike. We have looked at a few options but reporting on the Account Scorecard Scorecard fact seems to be limited. Due to separate issues with exporting Scorecards 2.0 reports (too many delimiters cause the exports to be too messy to use), we seem to have run out of options. 

The nature of the object relationship within the MDA Account Scorecard Scorecard Fact would perhaps require a left join function to produce a whole data set, or a left outer join to just get null scores. When scores are not set there's no Current Score table entry to match that Company record.

We can't resolve the left join error with a Data Space, as those are all inner joins. We could do so with a rule, but that would be problematic at best to build and maintain a separate MDA table to track null scores. 

Any ideas that anyone has would be greatly appreciated!