Skip to Content
avatar image
Former Member

FX Trans usign XDIM_FILTER

Hi BPC Friend

I would need to write a script that according a property of dimension entity the currency conversion program convert only in GBP so I thought to use the function

*XDIM_FILTER as shown below but it doesn't work

thanks

Michele

*XDIM_FILTER ENTITY= [ENTITY].PROPERTIES("CONVERT_USD")="N"

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATEGORY_SET%
CURRENCY = GBP
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = [ENTITY=%ENTITY_SET%]
*ENDRUN_PROGRAM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 10, 2017 at 02:50 PM

    *XDIM_FILTER ENTITY has no effect on CURR_CONVERSION execution!

    Write the following:

    *SELECT(%E%,[ID],ENTITY,ID=%ENTITY_SET% AND CONVERT_USD=N)
    
    *RUN_PROGRAM CURR_CONVERSION
    CATEGORY = %CATEGORY_SET%
    CURRENCY = GBP
    TID_RA = %TIME_SET%
    RATEENTITY = GLOBAL
    OTHER = [ENTITY=%E%]
    *ENDRUN_PROGRAM

    But other things are not clear:

    Do you want to run conversion in DM package?

    What the user will select in the prompt for ENTITY?

    Add comment
    10|10000 characters needed characters exceeded