Skip to main content
michael_sweeney
michael_sweeney
Helper ⭐️
April 24, 2018
Question

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

  • April 24, 2018
  • 1 reply
  • 54 views
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.

    1 reply

    steven_doty
    steven_doty
    Contributor ⭐️⭐️⭐️
    April 25, 2018
    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!
    Terms & ConditionsAccessibility statement