Question:
My client has requested to have two currency type for selection, example in the current cube, I have a currency type A defaulted EUR which reading monthly rate, then user requested to have an option to select currency type B which reading YTD rate, isn't possible to have two currency type in a KF/cube? thanks.
Answer:
Hi,
It is possible to have two currencies in the cube. In fact, in R/3, every document in modules such as FI, MM keeps local currency and a document currency. If I need both of these KF in the cube, I would have 2 KF's, each one having a different UOM, and in the transfer rule I would assign the currencies accordingly to the Currency unit characteristics.
Hope this is what you are looking for.
thanks
Answer:
Hi,
Sorry, I apologise for my bad typing, which caused you missunderstand my problem.
My question is, isn't possible to implement two currency translation type in a query? As I mentioned earlier, one is reading YTD rate and other is reading monthly rate. And user have the option select either one. Possible?
If yes, how can I differentiate which is reading monthly & YTD? Thanks.
Answer:
Hi,
Perhaps someone could give me some feeback, how this can be done.
I did search through the forum, but can't found a related topic.
In the query, I have implemented a curr translation YTD defaulted currency EUR applied to all KF, which reading exchange rate from table tcurr field KURST = Y. The rate is reading from GBP -> USD -> EUR.
Use want to have an option to select another curr translation monthly, reading exchange rate from table tcurr field KURST = M. The rate is reading from GBP -> USD -> EUR but exchange rate will be different from the above.
example YTD 02/28/05 (date as which ex. rate is effective)
rate rate rate
gbp usd eur
1.88041 0.76640
example monthly 02/28/05 (date as which ex. rate is effective)
rate rate rate
gbp usd eur
1.92345 0.74570
How can I implement two currency translation type in query? Meanwhile have an option for user to select either one? In the workbook, at KF when I right-click select currency translation, I saw there are numbers of currency translation type, how these work?
My base currency is GBP, so the database currency will be GBP right? And my target is EUR.
How abt target currency from database currency (EUR -> GBP? ) & by target currency using definition currency?
thanks.
Answer:
Bell,
I have same problem , I want to use monthly conversion rate in my query . But the query is taking latest rate. How to get monthly rate.
For eg
If I run the data for example
Month kf vlaue converted value rate Rate in Tcurr table for Type M
Jan $100 ₤ 180 1.8 1.78
Feb $100 ₤ 180 1.8 1.79
My question is how can i get dynamic rate value for each month .
Thanks in advance.
Sudhakar