Skip to Content
avatar image
Former Member

FX Trans usign XDIM_FILTER

Apr 10, 2017 at 02:31 PM | 115 Views

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

SAP Business Planning and Consolidation, version for SAP NetWeaver
bpc 10 nw
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Vadim Kalinin
    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