on 04-22-2006 8:46 AM
Hi BW challengers,
Q) I GETTING data from CRM system To BW and CRMsystrm getting data frmom diffenrent source system. each source system has its own time zone like Japan,US,UK,India.
my BW system is US PST zone.
according to time zones 1,2,34,7,8 Hourse diffrence thier dates chnges to US date.
I want Report in BEX user acessing from thir time Zone can get their reports only.
LIKE i want to take which purchese order created on which time and DATE.in my report. IS IT POSSIBLE.
IS IT POSSIBLE TO HANDLE THIS PROBLEM AT REPORING LEVEL TO CUSTMIZE AT VARIBALE EXITS.
FOR CUSTOMIZING WHICH FUNCTION MODULE IS SUITABLE ????
CAN WE HANDEL THIS AT DESIGN LEVEL?????
IS THERE ANY DIFFEREN WAY/SCENARIO TO HANDEL THIS PROBLE.
PLEASE TAKE THIS IS ONE BIGGEST ISSUE CAN ANY ONE SUGGEST TO HANDEL HOW.
WAITING FOR GOOD RESPONCE
HI,
You will have to record the time zone for the respective system in your modelling based on the data you get from. You can maintain a table in bw and assign the timezone to each system that you extact data from. You can also have system in your cube to identify the source system and related timezone.
Then we have a table in BW called TTZZT which holds all the time zone( if specific one has not been created by user).
SAP has standard funcation module TZ_LOCAL_TO_GLOBAL which converts time from local to global(UCT). You can use these information to build your logic in query varibale by using the timezone based on source system id etc..
hope it will help..
regards,
bhuwan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
In our sys we are using CRM & R3 in different region's
of the world.
Both CRM & R3 keep track of Time Zones in different way's.
What you need to do is bring all transaction records to the same TZ (we use PST).
You then can report on this TZ.
The way to do it is either in the extract or in Update rules (we use mostly in the extract).
Reg's
Edan
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.