Skip to Content
0

Currency Coversion running for the whole year rather than selected periods

Jan 23, 2017 at 05:03 PM

76

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Jan 23, 2017 at 05:26 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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...

0
Stephen Quayle Jan 24, 2017 at 08:24 AM
0

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


time.png (12.0 kB)
version.png (5.0 kB)
version.png (5.0 kB)
Show 1 Share
10 |10000 characters needed characters left 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.

0
Vadim Kalinin Jan 24, 2017 at 08:37 AM
0

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)

Share
10 |10000 characters needed characters left characters exceeded