SYMPTOM:
In Strategy 9.3.x - 9.4.x - 9.5.x, an unexpected SQL Join is generated when saving only Basic Statistics and removing the "RP Percentage Usage by Web Users" metric from the "33.3.1 Web Access Trends" Enterprise Manager report template.
STEPS TO REPRODUCE:
1 - Apply the following configuration:
Strategy Intelligence Server Configuration > Statistics > General > Server Level Session Statistics = Complete Session Logging:
Project Configuration - Enterprise Manager > Statistics > General = Basic statistics:
2 - Generate statistics by executing reports and documents from Strategy Web.
3 - Perform a manual data load from Strategy Enterprise Manager Console.
4 - Execute the report 33.3.1 Web Access Trends report to see the expected metric values.
5 - Remove from report template the "RP Percentage Usage by Web Users" metric.
6 - Re-execute the report to confirm that only 0 returns for the "RP Number of Web Jobs" metric.
CAUSE:
Checking the report SQL Statement, it is possible to confirm a Join on the IS_MESSAGE_FACT table instead of IS_REP_FACT.
Original report
from IS_REP_FACT a11 join #ZZMQ00 pa12 on (a11.IS_SESSION_ID = pa12.IS_SESSION_ID) join IS_SESSION a13 on (a11.IS_SESSION_ID = a13.IS_SESSION_ID)
from IS_MESSAGE_FACT a11 join #ZZMQ00 pa12 on (a11.IS_SESSION_ID = pa12.IS_SESSION_ID) join IS_SESSION a13 on (a11.IS_SESSION_ID = a13.IS_SESSION_ID)
