How to execute Native DB SQL under Microstrategy metric

In case you need to execute native DB SQL inside Microstrategy metric, you can use the following procedure:

  • #O = Is where the value of  MS Object will be included
  • <MS_OBJECT>= You can drag any MS Object: Text, Attribute, Metric, etc.

For instance, in case you need to apply a date mask in Oracle:

Tags: , ,