Skip to Content

Applying Currency conversion in SAP HANA with SAP BO Analysis Office

Hello Folks,

This document is to explain on how to apply currency translation in run time.

The below is the analytic view am using for which the currency translation has to be enabled:

Screen Shot 2013-12-26 at 2.14.10 PM.png

We would require ‘LOV’ to come up so that user can choose the currency he requires. To do this we need to define an input parameter of “Currency” type as shown below:

Screen Shot 2013-12-26 at 2.16.43 PM.png

Now we need to create a calculated column called “Cost” to enable currency translation as shown below:

We have to define a calculated column of type “Measure” and Goto Advance tab:

  1. Select type = ‘Amount with currency’
  2. Target Currency = Give the input parameter name / static value which will hold the dynamic input from the user to which the currency has to be converted
  3. Exchange type = Give the input parameter name / static value
  4. Conversion date = Give the input parameter name / static value
  5. Schema for currency conversion = Give the name of the schema which holds currency related tables like TCURR*
  6. Client for currency conversion = Give the client number based on which the conversion needs to take place

Screen Shot 2013-12-26 at 2.20.03 PM.png

Connecting to Analysis Office:

   1. Selecting the data source to login to the relevant SAP HANA database as shown below:


        Screen Shot 2013-12-26 at 2.21.27 PM.png

   2. Choose the data source and login as shown below:

Screen Shot 2013-12-26 at 2.22.33 PM.png

Output in AO:

Screen Shot 2013-12-26 at 2.23.28 PM.png

Screen Shot 2014-04-21 at 3.28.47 PM.png

Thus we are able to achieve the intended result.

Hoping this document has helped you in understanding “Currency Conversion” in SAP HANA using SAP BO Analysis Office

Please let me know your feedback on this.


Krishna Tangudu

You must be Logged on to comment or reply to a post.
  • Hi Krishna,

    That was good document, most of the snapshots are not visible clearly. Also here in this scenario you have shown on consuming HANA models in SAP BO Analyisis for office, however, can you let us know how did you established connection between SAP HANA and SAP BO Analysis for Office(is it OLAP connection or Relation Connection).

    Any other information regarding this scenarion please share with us.



    • Hi Venu,

      Thanks for your comments. In this one I have used Relation connection. But in the golive of the project OLAP connection is configured i guess.

      Do let me know the questions you are trying to find out in these scenario's so that I can help you to sort them out.


      Krishna Tangudu

  • Hello,

    Thank you for the article, I was wondering if you could explain why the Exchange type M was used, I tried to work with Exchange type = 1001 but I was receiving an error, when I used M it was successful. Is it because I am giving the conversion date as an input parameter?

    Kind regards,