Skip to Content
0
Nov 22, 2012 at 09:38 AM

FXTRANS Logic issue

175 Views

Hi Guru's

I am facing issue with currency translation, if I go per standard logic, validation is a problem. Hard coding not possible as I have many items in dimensions. Help me.

FXTRANS.LGS logic

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP = %GROUP_SET%

TID_RA = %TIME_SET%

OTHER = [ENTITY=%ENTITY_SET%]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

When executed: Error LOG:

UJK_VALIDATION_EXCEPTION:Dimension set:"CATEGORY" not assigned in Data Manager

Pasted below System constant.lgf and Data Manager script.

SYSTEM_CONSTANTS.LGF

//application constants

//--------------------------------------------

*FUNCTION CATEGORYDIM=C_CATEGORY

*FUNCTION TIMEDIM=TIME

*FUNCTION CURRENCYDIM=RPTCURRENCY

*FUNCTION ENTITYDIM=ENTITY

*FUNCTION ACCOUNTDIM=C_ACCT

*FUNCTION INTCODIM=INTERCO

*FUNCTION ACCDETAILDIM=C_FLOW

*FUNCTION DATASRCDIM=AUDITTRAIL

*FUNCTION GROUPDIM=SCOPE

// This part is needed when a RATE cube

// is associated to the application

// (FX = single or multi currency)

//---------------------------------------------

*FUNCTION THISAPP=CONS

*FUNCTION RATEAPP=RATES

*FUNCTION RATEENTITYDIM=R_ENTITY

*FUNCTION RATEACCOUNTDIM=R_ACCOUNT

*FUNCTION INPUTCURRENCYDIM=INPUTCURRENCY

*FUNCTION RATEENTITYMBR=Global

*FUNCTION RATESRCCALCMBR=Global

*FUNCTION AVGRATEID=AVG

*FUNCTION ENDRATEID=CLO

*FUNCTION HISTRATEID=HIST

Data Manager Script

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%GROUP_DIM%,%TIME_DIM%")

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

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

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

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

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

What we did:

When we have hard coded for each dimension item, we are not facing the error. For example script enclosed below.

*INCLUDE SYSTEM_CONSTANTS.LGF

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = Actual

GROUP = S_SAmerica

TID_RA = 2012.01

OTHER = [ENTITY=US]

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM