SYMPTOM:
When creating a report that contains data configured as Teradata TIMESTAMP(6), the data is displayed incorrectly, whereby dates are rounded up. As a consequence, any drilling on this figures uses the incorrect value.
EXAMPLE:
TIMESTAMP(6) Columns with value "2012-09-01 23:59:59.999999" (Teradata standard for end of day) are incorrectly displayed in reports as round up to following date:
"2012-09-02".
CAUSE:
This is a known issue with Strategy 10.x
ACTION:
Please contact Strategy Technical Support for an update.
The Strategy Internal Reference Number for the issue discussed in this technical note is 685729.