Skip to Content
author's profile photo Former Member
Former Member

How to display Currency Unit beside value in BEx Report?

Hi,

I have 2 separate Amounts in the columns area. Their respective currencies exist as Characteristics in Unit dimension. How do I display the amount along with currency unit beside it?

As of now my Report looks like....

Amount 1 Amount 2

2000 3000

I would like to display it as......

Amount1 CUR Amount2 CUR

2000 EUR 3000 USD

Thanks,

SD

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2009 at 11:21 AM

    Hi

    You need to maintain Key figures with the Fixed Currency / Fixed UOM at Tab page Type/Unit and uploaded with data.

    The Info Provider should have the Currency Unit suffixed to the Key Figs.

    If you have the same then you can just report with the Currency Unit .

    If you have lot of data already loaded with out Currency Unit try to concatenate the UOM .

    Check that you are not using NODIM for the Key Fig.

    Hope it helps and clear

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2009 at 11:09 AM

    Hii,

    Please check if you have maintained the currency for this keyfigures in backend. If yes then are the value getting loaded for the currencies. in the transformations.

    because the currency are by default displayed along with the Amounts in the Reports.

    Last option left is to check the Query, and on this keyfigure check if the NODIM option is applied on the keyfigures. that truncates the currency in the reports.

    hope this helps..

    Regards,

    Umesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Umesh,

      that is exactly what I dont understand. Normally the currncy unit should be displayed automatically beside the value. I checked the KF definitions and they are ok. Even the correct currency units are associated in the KF definition. I also checked the InfoCube content and it displays the KF values with their respective currency units.

      Could u elaborate a bit more on NODIM. As far as I know, NODIM is used in Formula definitions.

      Thanks,

      SD

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.