on 10-04-2008 4:54 PM
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.
re-opened
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
not answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Experts.. any suggestions ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.