EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB42476: 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 in MicroStrategy 10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


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.

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.
 
 


Comment

0 comments

Details

Knowledge Article

Published:

May 24, 2017

Last Updated:

May 24, 2017