KB225563: How to draw a vertical line in graph to highlight specific day in MicroStrategy 9.x and 10.x?

This Technical Note describes the steps to highlight a specific day, today, by adding a vertical line in a graph in Strategy 9.x and 10.x
 
Assume a sample line graph is being used, as below; there is a Day attribute on the X-axis.
 

To highlight a report execution day, today, follow the steps below:

• Define a Metric to get the date from the fact table at report level.
  

• Date(Max<FactID=Cost, UseLookupForAttributes=False>(Day)) {~+}
  Date function is added to truncate time part.
   
• Define a Metric to return if Metric created step 1 is equal to execution date.
  

• IF((DateMetric = Date(CurrentDate())), 1, 0)
  * DateMetric is the Metric defined in step 1.
  * Date and CurrentDate are Strategy functions.
  Enable smart metric in Subtotals/aggregation tab. 
• In the report in the above example, add the Metric created in step 2.
  When report is executed on January 22th, the result will be as below.
  

• Set the graph preference as below:
  ・Graph type - Combination: Dual Axis Bar Line
  ・For the Metric created in step 2, use bar graph and set the width to minimum
  

• The blue line (bar graph with minimum width) highlight the execution day.