Skip to Content
avatar image
Former Member

Currency Coversion running for the whole year rather than selected periods

Hi Experts,

I am having an issue with currency covnversion that the package is running for the whole year rather than the selected periods. The data for the actualised periods comes from our reporting model and the forcast is in out planning model. When the currency conversion in planning is run selected months say months 10-12 it is running for months 1-12. As the acutailsed data is opulling in both LC and GBP there is no rates entered against the actualised months in the rate mondel

I am using BPC 10.0 NW SP27

This is the logic

// select first to do month of forecast
*SELECT(%MONTH_ONE%,"BASE_VERSION_YEAR",VERSION,"ID=%VERSION_SET%")
// select year value of the time selection
*SELECT(%YEAR_REF_CONV%,"YEAR",TIME,"ID=%TIME_SET%")
// select timeid of the todo month of forecast
*SELECT(%MONTH_CONV%,"ID",TIME,"[TIMEID] >= '%YEAR_REF_CONV%.%MONTH_ONE%' AND [YEAR]=%YEAR_REF_CONV%")

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %VERSION_SET% //version selection
CURRENCY = GBP // currency to convert to
TID_RA = %MONTH_CONV% //time selection
RATEENTITY = Global //rate type to use
*ENDRUN_PROGRAM

Thanks in advace

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 23, 2017 at 05:26 PM

    Incorrect usage of TIMEID property. Please provide values you have in the properties used in the script.

    Add comment
    10|10000 characters needed characters exceeded

    • *SELECT(%MONTH_ONE%,"BASE_VERSION_YEAR",VERSION,"ID=%VERSION_SET%")

      What do you have in the property BASE_VERSION_YEAR? Month number???

      [TIMEID] >= '%YEAR_REF_CONV%.%MONTH_ONE%'

      TIMEID usially is something like: 20170100, 20170200...

  • avatar image
    Former Member
    Jan 24, 2017 at 08:24 AM

    Hi Vadim,

    Many thanks for your response.

    Attached is the TIMEIS & Base Version Year in that is being used in the dimension

    time.png

    version.png

    Regards

    Steve

    Add comment
    10|10000 characters needed characters exceeded

    • But in general instead of asking user to select some period to get a Year use PROMPT(COMBOBOX... with the list of Years and pass the selected year to the script as $$ variable.

  • Jan 24, 2017 at 08:37 AM

    The correct script will be:

    *SELECT(%MONTH_ONE%,[BASE_VERSION_YEAR],VERSION,[ID]=%VERSION_SET%) //08,09...
    *SELECT(%YEAR_REF_CONV%,[YEAR],TIME,[ID]=%TIME_SET%)
    *SELECT(%TID%,[TIMEID],TIME,[ID]=%YEAR_REF_CONV%.%MONTH_ONE%) //correct TIMEID
    *SELECT(%MONTH_CONV%,[ID],TIME,[TIMEID]>=%TID% AND [YEAR]=%YEAR_REF_CONV% AND [CALC]=N)

    Add comment
    10|10000 characters needed characters exceeded