KB320509: How to get system date using SQLServer as data warehouse in MicroStrategy 10.x?

This article is to show how to get system date if SQLServer is used as data warehouse in Strategy 10.x.

1. Create a metric with definition:
   

   
   ApplySimple("convert(varchar(12),getdate(),103)", " ")

   
   
2. Create a blank report and add the metric created in step 1.
3. Add another standard metric into the report.

Please note that if no standard metric is added to the report, the report SQL will not be generated correctly.