KB36340: SQL hint shows incorrect user information when the report cache is used in MicroStrategy SQL Engine 9.x-10.x

SYMPTOM:
 
In Strategy SQL Engine 9.x-10.x, when the report cache is used, SQL hint in the report SQL view shows incorrect user information.
 
 
 
 
STEPS TO REPRODUCE: 
 
 
Follow steps below to reproduce the issue with Strategy Tutorial project:
 
 
 
 

• In Strategy Developer, create a report and put the attribute Month in the row, as shown below:
   
  

• Go to Data menu and choose the option ‘VLDB properties’ as shown below:
   
  

• Add SQL hint “/*!u*/” under Select/Insert option, as shown below:
   
  

• Go to Project Configuration and enable cache, as shown below:
   
  

• Run the report as administrator in SQL view, note that the report cache is not used and SQL hint shows corrent user information, as show below:
   
  

• Switch another user to logon project source. Run the same report in SQL view, as show below:
   
   

Note that the SQL hint shows incorrect user information when the report cache is used.
    
 
CAUSE:
This is working as designed.
Once a cache is generated (by the first user running the report), the cache is used by Strategy SQL Engine for subsequent runs of the same report.
 
ACTION:
Disable report cache when using SQL hint in Strategy 9.x or Switch to Report Caching Per User from Project Configuration>Caching>Result Caches>Creation>Cache Creation Options>Create caches per user.