KB15589: Subtotal functions for all metrics are set to match those for the first one on re-execution of a report containing an object prompt with at least one compound metric in MicroStrategy

SYMPTOM
After creating a new report in Strategy, containing an object prompt with at least one compound metric, and then assigning a different function for the sub-total for each of the selected metrics, the totaling behavior will be as expected on the first execution.  However, if this report is re-executed, it may be noted that the function chosen for the sub-total assigned to the first metric on the report will be permeated through to affect all metrics.
 
STEPS TO REPRODUCE
This behavior may be reproduced in the Tutorial project by taking the following steps:

• Create an object prompt including at least one compound metric, such as Average Revenue and Profit Margin.
• Use this prompt in the columns of a new grid report.
• Add the Year and Quarter attributes to the rows and enable sub-totals:
  
  

• Set the evaluation order to calculate first the prompt and then the sub-totals:
  
  

• Run the report with all metrics selected.
• Create a new subtotal (across level), using a different function for each metric:
  
  

• The sub-totals are as expected and are displayed as follows:
  
  

• Save the report keeping at least the prompt on the template:
  
  

• Re-execute the report, selecting all the metrics:
  
  

• The function specified for the subtotalling on the first metric has been applied to all of those on the template: 
  
  

• Please note that the sub-totals are now different from those given on the first execution of the report:
  
  

CAUSE
This represents a known issue when executing a report in Strategy. 
 
ACTION
Currently, this issue is still being reviewed for feasibility by our Technology team, and it is not scoped for any upcoming scheduled Strategy release. 
 
 
KB15589