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

Currency Conversion

When i run currency conversion datamanager package,It shows status as success but the conversion is not happening

/CPMB/MODIFY completed in 0 seconds

Selection

-


(Member Selection)

ENTITY: India

CATEGORY: ACTUAL

RPTCURRENCY: USD

TIME: 2010.JAN

Messages

-


Application: SalesR Package status: SUCCESS

Script logic

-


*RUN_PROGRAM CURR_CONVERSION

CATEGORY =%CATEGORY_SET%

CURRENCY = %RPTCURRENCY_SET%

TID_RA = %TIME_SET%

OTHER=ENTITY=%ENTITY_SET%

R_ENTITY = GLOBAL

*ENDRUN_PROGRAM

Is there anything i am missing in script logic?

Advanced script logic:

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")

TASK(/CPMB/FX_RESTATMENT_LOGIC,SUSER,%USER%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SAPP,%APP%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/FX_RESTATMENT_LOGIC,LOGICFILENAME,FXTRANS.LGF)

Edited by: sapki6 on Oct 26, 2010 12:32 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 26, 2010 at 06:58 PM

    Do you see a FormulaLog in the left hand pane under PackageLog? Does it show something like the following:

    LOG BEGIN TIME:2010-10-26 13:46:26

    FILE:\ROOT\WEBFOLDERS\PacificDrilling\ADMINAPP\Finance\FXTRANS.LGF

    USER:CORP\C.TENNANT

    APPSET:PacificDrilling

    APPLICATION:Finance

    RUN CURRENCY CONVERSION

    0 SUBMITTED, 0 SUCCESS, 0 FAIL.

    SCRIPT RUNNING TIME IN TOTAL:2.34 s.

    LOG END TIME:2010-10-26 13:46:28

    If it is running correctly, then you should this, with values in place of the zeros for SUBMITTED, SUCCES, FAIL.

    Regards,

    Craig

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Can you please add the highlighted text to your script logic and retest the currency package:

      **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 you have all other settings configured as per the guide.

      Thanks,

      Sreeni

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

    Change your FXTRANS.LGF to

    *RUN_PROGRAM CURR_CONVERSION

    CATEGORY = %CATEGORY_SET%

    SELECT(%CURRENCY_SET_ID%,"[ID]",CURRENCY,"CURRENCY_TYPE='R'")

    TID_RA = %TIME_SET%

    RATEENTITY = GLOBAL

    OTHER = [ENTITY=%ENTITY_SET%]

    *ENDRUN_PROGRAM

    Check out the formula log and see if any number of records have been submitted as opposed to zeros and let us know how it goes

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Has it ever worked before?

      If not check your input currency and reporting currency dimensions and make sure properties are set up as per instructions on the Currency Translation white paper.

      Otherwise you need to ensure that the InfoCube you are working on is switched to Planning mode. i.e. "Real-Time Data Target Can be Planned; Data loading Not Allowed"

      Thanks,

      David.

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.