on 01-23-2013 2:37 AM
Hi,
I need to currency conversion for 15-Dec-2012 to USD and the exchange rates applicable for this is period 12-2012.
in Time ref. if i give fixed Time ref. and Time ref. varibale for certain period , do i need to use this Bex Query?
in Variable time Ref. if i give variable as Calender end period and info object as 0calmonth, do i need to do any settings in Bex query?
Hi Sudha,
Have a similar req regarding the time reference. Can you please confirm how you resolved?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Let me clarify once again what i require
for 01-11-2012 date the exchange rates should applicable are Dec-2012 year end exchange rates.
for 11-12-2011 date the exchange rates should applicable are Dec-2011 year end exchange rates.
for 24-01-2013 date the exchange rates should applicable are Jan-2013 period end exchange rates.
so for previous years year end exchange rates should apply and for current period only the current month end exchange rates should apply.
Please help me how can i achieve this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Whenever you make transfer global setting in BI , the latest currency values are updated automatically,
and now if you execute the report for 11-12-2011, the report will be based on the jan-2013 and not by DEC 2011,
whenever you make the transfer global setting, then the report will be based on the latest currency exchange rates values.
Hope u got it,
Regards,
RC
Hi,
Please start creating the Query and run the report for further issues. Please post the issues what you face..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suman,
in exchange rate type i given "M". currency tab i selected fixed target currency as "USD". in Time Ref. Tab i selected fixed time ref. as current date.
what i need is if i execute the query in particular day of Dec - 2012 all the exchange rates of 2012 - Dec should applicable and if i execute the query in Jan - 2013 all the exchange rates of 2013 - Jan should applicable for 2013 data and for 2012 data only 2012 exchange rates should applicable.
After giving this currency conversion nothing is changing in my case
please help me
Hi,
Refer the below document.
You need to try out with different time reference mentioned on page 7.
Regards,
AL
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
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.