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

KB486784: The time zone changes of Platform Analytics warehouse cannot be reflected for attributes Date, Hour, Minute


Shuang Qi

Senior Cloud Support Engineer II • Strategy


The time zone changes of Platform Analytics warehouse cannot be reflected for attributes: Date, Hour, Minute. Only Timestamp attribute will be updated by the change.

Symptom

When user needs to update data time zone for Platform Analytics warehouse, below tech note can be followed:
https://community.Strategy.com/s/article/How-to-Control-the-Time-Zone-for-Which-PostgreSQL-ODBC-Drivers-Fetch-Timestamps?language=en_US
But after updating database to the expected time zone, if using attributes Date, Hour, Minute, they would not be updated as per the change. Only Timestamp attribute data can take affect.

Solution

Currently it is by design, only Timestamp attribute data will be updated as per warehouse time zone setting changes. Please use Timestamp attribute in Platform Analytics report instead. If expecting attributes Date, Hour, Minute can be updated as well, please contact Strategy Tech Support for the supported timeline.


Comment

0 comments

Details

Knowledge Article

Published:

July 24, 2024

Last Updated:

July 24, 2024