Sales Management Customer Relationship Human Resources Business Performance BI & Data Quality IT Tools & Vendors

Sign-in   Register
Establishing 'Making it Happen' as a 'Formal & Predictable' Discipline
Principles and Rules Listing Page

Managing time-stamps across multiple time-zones

When you are recording events across multiple time-zones, its better to record both the local time as well as a common standard time (say GMT)
 
This page of 'Principles and Rules' is linked to:  Data Warehousing, Data Analysis/OLAP, BI platform Tools Evaluation, BI business intelligence end-to-end view,

When you are operating across multiple time-zones, one way is to record one time-stamp:

  • A common standard date along with the flag of the time-zone in which the event occurred, so that local time can be calculated at run-time.
  • The local time-stamp with the flag of the time-zone in which the event occurred so that the common reference time (say GMT) can be calculated.

This is not advisable, because it will put run-time load (as time dimension is most used dimension), and this run-time calculation may need to be plugged into various reports and queries that you are generating. Moreover sometimes the rules for calculating the local time given the GMT and vice-versa may not be that straight. Therefore it is advised to have both the time-stamps relating to two different time zone. However this should be done only for key time-zones for which you will need your reporting on. For the other time-zones, which could be used on occasional basis, one can do real time calculations.


Quick Feedback- Was this information helpful ?
Relevant Links to this page
TOPIC - Data Mart Business Theme Matrix in Data Warehouse Dimensional Model → Principles & Rules → Dimensional model has to be aligned to the Entity-Relationship → Principles & Rules → Always Use Conformed Dimensions → Principles & Rules → You may not be a able to have a perfect ETL → Practice Techniques → Handling Sparse Dimensional tables → Principles & Rules → Do not separate the parent and child line item data → Practice Techniques → Managing time-stamps across multiple time-zones → Practice Techniques → Recording events in multiple currencies → Practice Techniques → Handle different units of measure in the same fact table → Principles & Rules → Handling of Null foreign Keys in fact tables → Principles & Rules → Dimension Attributes as NULL → Principles & Rules → Don't rely too much on Meta Data Tools to enforce Business Intelligence → Principles & Rules → Don't wait for universal models for Data Marting → 
 
Back
 
Relevant links to this page
Data Mart Business Theme Matrix in DW
Dimensional model has to be aligned to the Entity-Relationship
Always Use Conformed Dimensions
You may not be a able to have a perfect ETL
Handling Sparse Dimensional tables
Do not separate the parent and child line item data
Managing time-stamps across multiple time-zones
Recording events in multiple currencies
Handle different units of measure in the same fact table
Handling of Null foreign Keys in fact tables
Dimension Attributes as NULL
Don't rely too much on Meta Data Tools to enforce Business Intelligence
Don't wait for universal models for Data Marting
Additional Channels
Principles & Rules
Free Templates
Glossary
Key Performance Indicators

Most Popular Zones with list of pages crossing 25000 hits  →→→ 
Maximising Sales Performance
Sales Channel Management Overview
Sales Compensation for Consistency
Sales productivity
Sales Synergies
Sales Channel Mix Profitability
Read more...
  Customer Relationship Management
Customer Segmentation Parameters
Customer Value and Profitability Tips and Actions
Exit barriers for Customer Retention
Customer Value and Profitability-Overview
Customer Satisfaction and Retention- Overview
Read more...
  Human Resources & Leadership
Empower Front-line Employees
Fostering Innovation
People become the way you treat them
Develop Self and Others
Developing Leaders- Few Leadership Traits
Read more...
 
 
Business Performance & Planning
Strategic Vision and Mission
Individual goal Sheet
strategy blueprint Rationalize Align and Publish
Stakeholder test for Scorecard
Scorecards need manual finish
Read more...
  Business Intelligence & Data Quality
Data Warehouse Test Scenarios
Dimensional vs relational storage
Metadata Architecture Design
Business Process Controls
Master-Data-Management CDI Architecture
Read more...
  IT Vendors & Tools Management
Extraction, Transformation and Loading
OLAP Server write backs
Vendor Partnership and alliance Evaluation
Multi Layer Architecture
Vendor Credentials and Track-Record Evaluation
Read more...