Tecnico

Currency Conversion in BI 7.0

Applies to:
SAP Business Intelligence 7.0. For more information, visit the Business Intelligence homepage.

Summary
The objective of this Document is to explain different ways of performing currency translation in BI. Author: Ramakrishna Gattikoppula

Company: Infosys Technologies Limited. Created on: 8 October 2009

Author Bio
Ramakrishna Gattikoppula isa Software Engineer at Infosys Technologies Limited. He has been involved in SAP BW Implementation Projects.

SAP COMMUNITY NETWORK © 2009 SAP AG

SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com 1

Currency Conversion in BI 7.0

Table of Contents
CURRENCY CONVERSION IN BI 7.0.......................................................................................................................... 3 1. Currency Translation Type ............................................................................................................................. 4 1.1 Creating Currency Translation Type ......................................................................................................... 4 2. Defining Target Currencies Using InfoObjects............................................................................................... 9 2.1 Determine Target Currency for currency conversion from InfoObject ...................................................... 9 3. Currency Translation in Business Explorer .................................................................................................. 12 3.1 Currency translation in querydefinition................................................................................................... 12
3.1.1 Currency translation in query definition (Fixed Target Currency) ...................................................................... 12 3.1.2 Currency translation in query definition (Target Currency determined through selection variable) ................... 13 3.1.2.1 Variable in the currencytranslation type ........................................................................................................ 13 3.1.2.2 Variable in properties of the keyfigure in BEx ................................................................................................ 15

3.2 Currency translation in the executed query............................................................................................ 17 4. Currency Translation during Transformation ................................................................................................ 18 5. Variable Time References in Currency Conversions ................................................................................... 19 6. References................................................................................................................................................... 20 Copyright............................................................................................................ Error! Bookmark not defined.

SAP COMMUNITY NETWORK © 2009 SAP AG

SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com 2

Currency Conversion in BI 7.0

Currency Conversion in BI 7.0
Currencytranslation is used to translate the key figures with currency fields that exist in the source system in different currencies into a standard currency in the BI system. Currency translation can be done at different levels depending on requirements and based on translation type. Below Figure gives an overview about where currency translation comes into picture in BI.

Currency translation isbased on currency translation types. A combination of source and target currency, exchange rate type, time reference for conversion is used to determine exchange rate which in turn is used for performing the currency translation.

SAP COMMUNITY NETWORK © 2009 SAP AG

SDN - sdn.sap.com | BPX - bpx.sap.com | BOC - boc.sap.com 3

Currency Conversion in BI 7.0

1. Currency Translation Type
A...