How to resolve report issue based on metrics package from version 10.1.0 to version 10.1.1

Check list of all posts

Problem
When upgrading metrics package version from 10.1.0 to 10.1.1, report based on this package doesn’t work anymore. metrics


Analysis
When importing FM metrics package from version 10.1.0, report works. As soon as FM metrics package opened by FM 10.1.1 is published to content store, report stops working. By comparing generated SQL statements, you can see there are huge differences. The main difference is that MOD_SCORECARD_GROUPS comes to play.  Changing report to force report use MOD_STRATEGY_METRICS , report is generated with same result, but with extremely slow performance.  Looking into metrics, you’ll find the SQL is much longer and very slow when running in Query analyzer.


Solution
The solution is to remove the join between Metrics and MOD_SCORECARD_GROUPS
And the join between Strategies and MOD_SCORECARD_GROUPS