Skip to Content
avatar image
Former Member

BEx problem to display currency other than USD

Hi,

We have loaded data into InfoCubes with ZAMOUNT key figure. When I check the data data in the InfoCube its showing exactly what I loaaded into Cubes( with currency). When I open the same report in BEx the ZAMOUNT value is multiplying with 100 and for some currencies multiplying with 0.1 etc othet than USD. any ideas?

Thanks,

Ram

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 09, 2004 at 06:11 AM

    Hi,

    you should check the decimal places of your currency in customizing.

    Spro->General Settings->Currency->Set decimal places for currency

    If it is 0, than the system will internally store 100 as 1,00 and while reporting multiply 1,00 with 100 to get the correct result. If you have 4 decimal places then the system will store 100 as 10000,00 and will later on devide by 100.

    If the decimal setting is correct from your point of view and you loaded data via flat file, check the currency conversion for external system flag in the infoPackage.

    Heike

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      just for clarification:

      - In BEx you see 12300 GRd

      - In Infocube you see 123 GRd

      - Decimals for GRd are set to 0.

      => System works correctly (see explanation before) Data in Infocube is wrong. Also please have a look at note 153707.

      - You have to transfer external currency format (how it is stored in your database table) to internal currency format during transfer routines.

      Regards

      Heike