cancel
Showing results for 
Search instead for 
Did you mean: 

How to design EDW for source systems from different Time-Zones

Former Member
0 Kudos

How to design EDW for source systems from different Time-Zones?

Suppose IT landscape has a global BW in New York, and source systems in americas, europe and asia, then how the time-zones effect on time related things like delta selections on date or timestamp etc.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

re-opened

Former Member
0 Kudos

As you said BW is global in NY, your source system must be global too. People from various locations can connect to same source system and thus timestamps for delta is always maintained as 1 single time. We have same scenario in our project. Our R/3 system is used by users in US and Europe. So we run deltas twice in day to make sure we got deltas from both locations.

If scenarios was such that all locations connect to separate R/3 system, then obviously you have multiple queues. That is unique delta queue for each source system so deltas will be pulled as per data in respective queues.

Abhijit

Former Member
0 Kudos

Thanks a lot Abhijit,

I have one more question with your scenario, Does users in Europe and America post transactions in their local timezones, or all users from Europe and America uses one global timezone like UTC(Greenwich mean time)?

If it is, then how the delta determined, on what timestamp? especially in FI we can't get two delts in one day unless we change paremeters in standerd timestamp tables.

Edited by: manyam ch on Nov 16, 2008 1:53 PM

Former Member
0 Kudos

Delta is always determined on System time. You can find that time by clicking Status menu from any SAP screen and selecting Status time. Normally System time is set always 1 standard time. It could be GMT or any specific time. In our case its EST time. Local time can be always different for any system. But delta is checked using System time.

Abhijit

Former Member
0 Kudos

not answered

Former Member
0 Kudos

Experts.. any suggestions ?