FX Trans usign XDIM_FILTER

[Former Member]

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

[former_member186338 · Accepted solution]

*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?

[Former Member · Accepted solution]

PERFECT, IT WORKS!!

For example the user select the entity 2300, 2400,2500

I want for the entity 2300 only GBP, for the entity 2400 GBP & USD and for the entity 2500 nothing

Using the following script

*SELECT(%CURRENCYVARIANT%,"ID","RPTCURRENCY","[REPORTING]='Y'")

*SELECT(%CONVERTGBPUSD%,[ID],ENTITY,ID=%ENTITY_SET% AND CONVERT_USD=Y)

*FOR %CATS%=%CATEGORY_SET%

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATS%
//CATEGORY = ACTUAL
//CURRENCY = %RPTCURRENCY_SET%
CURRENCY = %CURRENCYVARIANT%
//GROUP = %GROUPS_SET%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = [ENTITY=%CONVERTGBPUSD%]
*ENDRUN_PROGRAM

*NEXT

*SELECT(%ONLYGBP%,[ID],ENTITY,ID=%ENTITY_SET% AND CONVERT_USD=N)

*FOR %CATS%=%CATEGORY_SET%

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATS%
//CATEGORY = ACTUAL
//CURRENCY = %RPTCURRENCY_SET%
CURRENCY = GBP
//GROUP = %GROUPS_SET%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = [ENTITY=%ONLYGBP%]
*ENDRUN_PROGRAM

*NEXT

I got the following

what do you think?

thanks

Michele

[former_member186338 · Accepted solution]

Yes, my script is exactly for this case!

[Former Member · Accepted solution]

thanks

I don't know why it doesn't work anymore

I run the package for entity 2600 and I got the following

[former_member186338 · Accepted solution]

And 2600 is not N?

[Former Member · Accepted solution]

it was blank

now I have type in Y

I will let you know, thanks for now

[former_member186338 · Accepted solution]

Doesn't matter blank or Y

The code have to skip CURRENCY conversion if %E% is empty.

To implement it you have to write:

*XDIM_SKIPNULLCHECK CURRENT

with corresponding XDIM_MEMBERSET ENTITY=...

[former_member186338 · Accepted solution]

Something like:

*SELECT(%CURRENCYVARIANT%,"ID","RPTCURRENCY","[REPORTING]='Y'")
*SELECT(%CONVERTGBPUSD%,[ID],ENTITY,ID=%ENTITY_SET% AND CONVERT_USD=Y)

*XDIM_SKIPNULLCHECK CURRENT
*XDIM_MEMBERSET ENTITY=%CONVERTGBPUSD%
*FOR %CATS%=%CATEGORY_SET%

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATS%
//CATEGORY = ACTUAL
//CURRENCY = %RPTCURRENCY_SET%
CURRENCY = %CURRENCYVARIANT%
//GROUP = %GROUPS_SET%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = [ENTITY=%CONVERTGBPUSD%]
*ENDRUN_PROGRAM

*NEXT
*COMMIT

*SELECT(%ONLYGBP%,[ID],ENTITY,ID=%ENTITY_SET% AND CONVERT_USD=N)

*XDIM_SKIPNULLCHECK CURRENT
*XDIM_MEMBERSET ENTITY=%ONLYGBP%

*FOR %CATS%=%CATEGORY_SET%

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATS%
//CATEGORY = ACTUAL
//CURRENCY = %RPTCURRENCY_SET%
CURRENCY = GBP
//GROUP = %GROUPS_SET%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = [ENTITY=%ONLYGBP%]
*ENDRUN_PROGRAM

*NEXT
*COMMIT

Please read note:

https://launchpad.support.sap.com/#/notes/2146749/E

[Former Member · Accepted solution]

perfect, it works

thanks a lot