Skip to Content

   Business Scenario:

   Bex Query is showing all values perfectly and balance amounts with its proper currency key, but higher management and reporting user wants balance      

   amounts/Key figures with its currency symbol for all the Bex queries.

   Query Output with standard design option:

   The Query output with default setting for currency ;

   Sample query:

/wp-content/uploads/2012/05/clip_image002_99466.jpg

  Currency key is appearing after values of amount key figure.

 

  Report requirement

  Reporting user wants query output with currency sign before values of amount key figure as shown in below image:

  /wp-content/uploads/2012/05/clip_image003_99503.jpg

    

   Procedure to be followed:

  Execute transaction code – SPRO, SAP Project Reference Object

   Execute SPRO transaction code in BW system, this transaction code is mainly used to configure the setting as per your client requirement by using the

   standard setting present in the system and also used for making necessary customizing in the system for the Key data structure and Configurations.  

   SPRO -> SAP Reference IMG -> SAP NetWeaver -> Business Intelligence->Settings for Reporting and Analysis.

   /wp-content/uploads/2012/05/clip_image004_99504.jpg

  

   Settings for Reporting and Analysis

   Settings for Reporting and Analysis -> General Settings for Reporting and Analysis -> Set Alternative Currency Display

   /wp-content/uploads/2012/05/clip_image005_99505.jpg

  

  Click on /wp-content/uploads/2012/05/clip_image008_99512.jpgto set Alternative Currency Display; it will pop up a caution message.

  Caution: The table is cross-client; this message serves to warn you that each change you make will have an effect on all other clients in the system. Click on 

  “continue”.

  Click on “New Entries” tab and maintain Currency symbol against currency key as shown in below image and then click  save button/wp-content/uploads/2012/05/clip_image010_99514.jpg

/wp-content/uploads/2012/05/clip_image006_99519.jpg

  1.  Currency: enter currency keys.

  2.  Alt. text (Alternative text): enter currency symbol for its relevant currency key.

  3.  Before/After Value: option decides how currency symbol (alternative text) will appear with value in Bex query.

     e.g. If Currency key is EUR then value outputs for

Before value: € 1000 (€ displayed in front of the numeric value)

After value: 1000 € (€ displayed after the numeric value)

  Note: SAP Standard settings:

          1. All currencies are displayed in accordance with the ISO norm by default, and appear after the numeric value,

             Except  

          2. DEM is displayed as DM,

          3. USD is displayed as $ in front of the numeric value,

          4. GBP is displayed as £ in front of the numeric value.        

  Query output

/wp-content/uploads/2012/05/clip_image007_99524.jpg

                                                                                                                                  

To report this post you need to login first.

13 Comments

You must be Logged on to comment or reply to a post.

  1. vinod bokade

    Nice Work Avinash……clearly explained and very useful information, can be used in any BI project.

    Qu : Is this setting is user specific or applicable to whole system ?

           Is it possible to capture it in transport request to move to different environment ?

    (0) 
    1. Avinash Verma Post author

      Hi,

      This setting is applicable for whole system and yes we can capture this setting in separate transport request to move to different systems.

      Table view (top left) -> Transport

      Regards,

      Avinash

      (0) 
  2. Vivekanand Mada

    can we make this setting applicable to only a particular report ? so that the rest of the reports can have a normal EUR,USD type display..is it possible ?

    (0) 
  3. Manohar Delampady

    Nice document Avinash and great explanation.  I believe SPRO is a system setting, so it will have a global impact on that particular system. But would there be an easier way to achieve this only for certain queries, as asked before by Vivek here ?

    Regards,

      Manohar. D

    (0) 
    1. Avinash Verma Post author

      Hi Manohar and Vivek,

      Thanks for your feedback..!

      Yes, SPRO is global level setting and it will be applicable for all queries in that particular system.

      I don’t think there would be option to set this setting only for certain queries. but still have to explore if there is any query specific work around.

      Regards,

      Avinash

      (0) 
      1. Manohar Delampady

        Just a random thought in the same line… In SPRO when the settings are changed, they are for sure saved in an underlying table, so if this table is figured out and an exit is used for the specific queries to convert the symbols back to their names referring to this table, then this might be achievable to have certain queries with display independent of the global settings. Hope SAP has given us a place to write this exit just to address the display of the report.

        Regards,

          Manohar. D

        (0) 
  4. Yasemin ULUTURK

    Hi Avinash,

    Very nice information. Thank you for sharing. I checked in my system that in this configuration I don’t have any configured item, though, in reports I see some currencies before and some after the value. Do you have any idea why that happens?

    Thank you very much.

    Regards

    Yasemin…

    (0) 

Leave a Reply