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

KB483314: The Timestamp Logged in the Platform Analytics Warehouse Only Displays in UTC Time


Lisha Ma

Senior Cloud Support Engineer III • MicroStrategy


This article details why the timestamp logged in the Platform Analytics warehouse is not displaying the correct time.

Symptom 


After configuring Platform Analytics, the timestamp logged in the Platform Analytics warehouse is not displaying as the local time but as UTC time. 
 

Local Time

ka04W000000OcupQAC_0EM2R000000h838.jpeg

 

Timestamp int he PA Warehouse

ka04W000000OcupQAC_0EM2R000000h83D.jpeg

 

Cause


This is working by design.
The Time hierarchy attributes are based on the UTC time zone. Both the Strategy Intelligence server and the Identity server send the server's time zone with the transactional logs. The time zone is then standardized to UTC in the Platform Analytics ETL.
For more information on the Platform Analytics' data model, see Platform Analytics Data Directory .
 


Comment

0 comments

Details

Knowledge Article

Published:

May 23, 2019

Last Updated:

May 23, 2019