Saturday, May 4, 2013

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

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

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.

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

No comments:

Post a Comment