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

Currency Translation -Reporting type

Hi,

We are trying to do currency translation on planning application in APSHELL(SAP Delivered one) applicationset and we maintained all required properties and members for currency translation as mentioned in "How to do Currency Translation for Financial Application using SAP BusinessObjects Planning and Consolidation 7.0 for the SAP NetWeaver Platform" document.When we are running Datamanger "FXRestament" by passing valid values (Entity C9000,Category PLAN,RPT Currency USD,Year 2009.MAY) datamanger is running succesfully but in the formual log we are getting below message and currency translaiton is not happening

APPSET:APSHELL

APPLICATION:PLANNING

RUN CURRENCY CONVERSION

0 SUBMITTED, 0 SUCCESS, 0 FAIL.

SCRIPT RUNNING TIME IN TOTAL:1.97 s.

but in the listcube of planning application we could see data for entity C9000, Category PLAN, RPTCurrency LC,Year 2009.MAY and also exchange rate is mainted for the year 2009 in rate application but currency translation is not happening.

Script logic we used for currency translaiton in planning application is as below

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

OTHER = [ENTITY=%ENTITY_SET%]//For More than one other scope parameters: OTHER = [ENTITY=%ENTITY_SET%;INTCO=%INTCO_SET%...]

*ENDRUN_PROGRAM

Please advise on the above issue.We are using BPC NW7.0 SP07

Thanks

UDAY

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 13, 2010 at 12:11 PM

    Hi,

    Please remove the OTHER in the ENTITY assumption of your script, and try executing the logic,

    *RUN_PROGRAM CURR_CONVERSION
    CATEGORY = %CATEGORY_SET%
    TID_RA = %TIME_SET%
    ENTITY=%ENTITY_SET%
    RATEENTITY = GLOBAL
    *ENDRUN_PROGRAM
    

    Also Ensure that this logic works only if the values are in Local Currency ie, the CURRECY_TYPE property of the currecy should be L. This logic converts the values in Local Currency to other Reporting Currency which have CURRENCY_PROPERTY as R.

    Hope this will help.

    Regards,

    G.Vijaya KUmar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2010 at 07:01 PM

    check following -

    1. Category Dimension - YEAR should be same as in TIME dimension. It must be 'numeric'

    2. Enter following in FXTRANS.LGF -

    *SELECT(%RPTCURRENCYVARIANT%, "ID" , "RPTCURRENCY", "[CURRENCY_TYPE]='R'")    
    *RUN_PROGRAM CURR_CONVERSION
           
         CATEGORY = %CATEGORY_SET%
         TID_RA = %TIME_SET%
         CURRENCY = %RPTCURRENCYVARIANT%
         RATEENTITY = GLOBAL
         OTHER = [ENTITY=%ENTITY_SET%]
    *ENDRUN_PROGRAM

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2011 at 09:57 AM

    Hello,

    We are facing similar issue, What is solution for this problem.

    Quick help would be highly appreciated.

    Regards,

    Ankit Udeshi

    Add a comment
    10|10000 characters needed characters exceeded

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.