When manual measures exist on Scorecard, that have never had a value loaded to that measure, there is no record in the Unified Scorecard Fact table.
This can be problematic when trying to determine how many accounts do not have a score yet. For example, our CS Perspective measure which is a manual subjective score. To report on accounts that do not have an entry in that score, we have to create a Data Designer set to include all the NA records alongside the records with a value.
Would be helpful if Unified Scorecard Fact table contained an NA record when there has never been a value entered.