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.
Page 1 / 1
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!
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!
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.