Currency conversion package error 10.1nw

[Former Member]

Hi Experts,

We are getting "Failed to get parameter LOGICFILENAME" when we ran currency conversion package in production.

Same package is working fine in Test environment,

recently environment moved to production.

i have checked the k2 script and script logic in both environments are matching.

This is the K2 script we are using

PROMPT(SELECTINPUT,,,,"%TIME_DIM%")

TASK(/CPMB/ICDATA_LOGIC,SUSER,%USER%)

TASK(/CPMB/ICDATA_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/ICDATA_LOGIC,SAPP,%APP%)

TASK(/CPMB/ICDATA_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/ICDATA_LOGIC,LOGICFILENAME,FXTRANS.LGF)

Version of bpc is 10.1 nw embeded.

Let me know ifyou need any more deetails

[Former Member]

Thanks all for your support.

issue is resolved after doing below steps:

1) refreshed process chain of icdata

2) recreated the package

3) ran it

Its resolved.

[former_member186338]

Then close the discussion!

The issue was in process chain?

[former_member225135]

Hi Raj,

Try using Default formula process chain (/CPMB/DEFAULT_FORMULAS)

ICDATA process chain is used for running IC BOOKING process

Regards,

Rahul

[former_member186338]

Hi Rahul,

Absolutely incorrect!

DEFAULT_FORMULAS is the same chain as ICDATA

Both can be used to run ANY script logic!

Vadim

[former_member186338]

Script logic in embedded BPC? ??

[Former Member]

sorry, i am in classic version.

this is script selection

*SELECT(%CURRENCY%, ID, CURRENCY, "CURRENCY_TYPE=T")

*XDIM_MEMBERSET CURRENCY = %CURRENCY%

*XDIM_MEMBERSET CATEGORY = FORECAST

*XDIM_MEMBERSET ACCOUNT = 100004,100006

*XDIM_MEMBERSET TIME =%TIME_SET%

[former_member186338]

First check that you have FXTRANS.LGF in this model. Then provide full script text.

[Former Member]

*SELECT(%CURRENCY%, ID, CURRENCY, "CURRENCY_TYPE=T")

*XDIM_MEMBERSET CURRENCY = %CURRENCY%

*XDIM_MEMBERSET CATEGORY = FORECAST

*XDIM_MEMBERSET JV_ACCOUNT = 100004,100006

*XDIM_MEMBERSET TIME =%TIME_SET%

*XDIM_MEMBERSET AUDITTRAIL=BAS(OPPTOTAL),BAS(MA_TOTAL), EPC

*FOR %R_CURR%=CURRNECY

*LOOKUP Rates

*DIM CATEGORY="FORECAST"

*DIM R_ENTITY="FEA"

*DIM R_ACCOUNT="AVG"

*DIM SOURCECURAUD:INPUTCURRENCY="AUD"

*DIM SOURCECURCAD:INPUTCURRENCY="CAD"

*DIM SOURCECUREUR:INPUTCURRENCY="EUR"

*DIM SOURCECURGBP:INPUTCURRENCY="GBP"

*DIM SOURCECURJPY:INPUTCURRENCY="JPY"

*DIM SOURCECURKRW:INPUTCURRENCY="KRW"

*DIM SOURCECURMYR:INPUTCURRENCY="MYR"

*DIM SOURCECURNOK:INPUTCURRENCY="NOK"

*DIM SOURCECURSGD:INPUTCURRENCY="SGD"

*DIM SOURCECURUSD:INPUTCURRENCY="USD"

*DIM MEASURES="PERIODIC"

*ENDLOOKUP

*FOR %N% = 1,2,3

*XDIM_ADDMEMBERSET TIME=TMVL(%N%,%TIME_SET%)

*WHEN CURRENCY

*IS T_AUD

*REC(FACTOR=0,CURRENCY="USD_AU")

*REC(FACTOR=LOOKUP(SOURCECURAUD),CURRENCY="USD_AU")

*IS T_CAD

*REC(FACTOR=0,CURRENCY="USD_CA")

*REC(FACTOR=LOOKUP(SOURCECURCAD),CURRENCY="USD_CA")

*IS T_EUR

*REC(FACTOR=0,CURRENCY="USD_EU")

*REC(FACTOR=LOOKUP(SOURCECUREUR),CURRENCY="USD_EU")

*IS T_GBP

*REC(FACTOR=0,CURRENCY="USD_GB")

*REC(FACTOR=LOOKUP(SOURCECURGBP),CURRENCY="USD_GB")

*IS T_JPY

*REC(FACTOR=0,CURRENCY="USD_JP")

*REC(FACTOR=LOOKUP(SOURCECURJPY),CURRENCY="USD_JP")

*IS T_SGD

*REC(FACTOR=0,CURRENCY="USD_SG")

*REC(FACTOR=LOOKUP(SOURCECURSGD),CURRENCY="USD_SG")

*IS T_KRW

*REC(FACTOR=0,CURRENCY="USD_KR")

*REC(FACTOR=LOOKUP(SOURCECURKRW),CURRENCY="USD_KR")

*IS T_MYR

*REC(FACTOR=0,CURRENCY="USD_MY")

*REC(FACTOR=LOOKUP(SOURCECURMYR),CURRENCY="USD_MY")

*IS T_NOK

*REC(FACTOR=0,CURRENCY="USD_NK")

*REC(FACTOR=LOOKUP(SOURCECURNOK),CURRENCY="USD_NK")

*IS T_USD

*REC(FACTOR=0,CURRENCY="USD_US")

*REC(FACTOR=LOOKUP(SOURCECURUSD),CURRENCY="USD_US")

*ENDWHEN

*NEXT

*NEXT

[former_member186338]

Show some screenshots of lgf file to see the name!

[Former Member]

[former_member186338]

And the script is strange and incorrect!

What for:

*FOR %R_CURR%=CURRNECY ????

%R_CURR% will get only one value - CURRNECY

and other issues!

Can you explain what do you want to achieve with this script???

[former_member186338]

The correct script without useless lines will be:

*SELECT(%CURRENCY%, ID, CURRENCY, "CURRENCY_TYPE=T")

*XDIM_MEMBERSET CURRENCY = %CURRENCY%

*XDIM_MEMBERSET CATEGORY = FORECAST

*XDIM_MEMBERSET JV_ACCOUNT = 100004,100006

*XDIM_MEMBERSET TIME =%TIME_SET%,TMVL(1,%TIME_SET%),TMVL(2,%TIME_SET%),TMVL(3,%TIME_SET%)

*XDIM_MEMBERSET AUDITTRAIL=BAS(OPPTOTAL),BAS(MA_TOTAL), EPC

*LOOKUP Rates

*DIM R_ENTITY="FEA"

*DIM R_ACCOUNT="AVG"

*DIM SOURCECURAUD:INPUTCURRENCY="AUD"

*DIM SOURCECURCAD:INPUTCURRENCY="CAD"

*DIM SOURCECUREUR:INPUTCURRENCY="EUR"

*DIM SOURCECURGBP:INPUTCURRENCY="GBP"

*DIM SOURCECURJPY:INPUTCURRENCY="JPY"

*DIM SOURCECURKRW:INPUTCURRENCY="KRW"

*DIM SOURCECURMYR:INPUTCURRENCY="MYR"

*DIM SOURCECURNOK:INPUTCURRENCY="NOK"

*DIM SOURCECURSGD:INPUTCURRENCY="SGD"

*DIM SOURCECURUSD:INPUTCURRENCY="USD"

*DIM MEASURES="PERIODIC"

*ENDLOOKUP

*WHEN CURRENCY

*IS T_AUD

*REC(FACTOR=LOOKUP(SOURCECURAUD),CURRENCY="USD_AU")

*IS T_CAD

*REC(FACTOR=LOOKUP(SOURCECURCAD),CURRENCY="USD_CA")

*IS T_EUR

*REC(FACTOR=LOOKUP(SOURCECUREUR),CURRENCY="USD_EU")

*IS T_GBP

*REC(FACTOR=LOOKUP(SOURCECURGBP),CURRENCY="USD_GB")

*IS T_JPY

*REC(FACTOR=LOOKUP(SOURCECURJPY),CURRENCY="USD_JP")

*IS T_SGD

*REC(FACTOR=LOOKUP(SOURCECURSGD),CURRENCY="USD_SG")

*IS T_KRW

*REC(FACTOR=LOOKUP(SOURCECURKRW),CURRENCY="USD_KR")

*IS T_MYR

*REC(FACTOR=LOOKUP(SOURCECURMYR),CURRENCY="USD_MY")

*IS T_NOK

*REC(FACTOR=LOOKUP(SOURCECURNOK),CURRENCY="USD_NK")

*IS T_USD

*REC(FACTOR=LOOKUP(SOURCECURUSD),CURRENCY="USD_US")

*ENDWHEN

[former_member186338]

And you have to check ICDATA chain in transaction RSPC: