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