KB42391: The Interactive Bubble Graph tooltip doesn’t show the correct metric value in MicroStrategy Web

SYMPTOM:
In Strategy Web 9.x, when an Interactive Bubble Graph is created with 3 attributes in the rows, the tooltip for the bubbles don’t show the correct metric values. Instead of aggregating the metrics at the level of the attribute represented in the bubble, it is calculating it at the lowest attribute level in the underlying dataset.
 
STEPS TO REPRODUCE:

• Create a report with the “Year”, “Quarter” and “Month of Year” attributes in the rows and the “Cost”, “Revenue” and “Profit” metrics in the columns.
• Execute the report.
• Verify the value metrics. Observe the value of “Revenue”, “Cost”, and “Profit” ($502,224, $413,050, and $89,174, respectively) on the first row.

• Create a dashboard and add the report above as dataset.
• Convert the grid into an “Interactive Bubble Graph” widget.
• Execute the dashboard in Flash Mode.
• Right click on the widget and select “Properties”.
• Click on the “Drilling” tab in the pop-up dialog and click the “Enable drilling” check box, like shown below.

• The value for each of the metrics do not corresponds of the element “2009 Q1” in the Quarter attribute, but correspond to the “January” element in the Month attribute.
  

CAUSE:
This is working as designed, the Interactive Bubble Graph Widget considers the metric values on the first row for each Quarter elements as a Quarter subtotal.
 
ACTION:

• Right click on the widget in design mode and select “Edit Totals”.
• Go to the “Advanced” tab and enable subtotal for the lowest attribute, as shown below.

• Go to “Display” tab and select “Top of each level” under “Subtotal positions by row”, like shown below.

• Execute the dashboard in Flash Mode.
  

• ff

For more information on a similar issue, refer to the following technical note:
KB35880: The first element of child attribute is missing after drilling down from an Interactive Bubble Graph widget in MicroStrategy Web 9.x