In case you need to execute native DB SQL inside Microstrategy metric, you can use the following procedure:
1 |
ApplySimple("#O",<MS_OBJECT>) |
- #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:
1 |
ApplySimple("to_char(#O,'dd/mm/yyyy')",DATE@ID) |