Hi,
I am using BPC Version 7.0.104 MS
OS: 2003 server edition
I have created one application "Consolidate_1" using new dimension in it "C_Acct" , "C_Datasrc" ,"C_FLOW" and "C_Category"
RATE1 application has been created and successfully imported.
(Validation of Transformation file, Package execution and script logic validated)
Well i am facing problem in the script logic for the consoildate_1 application
I have modified my SYSTEM_CONSTANT.LGF file (from adminapp/consolidate_1) as follows:
// application constants //
*FUNCTION CATEGORYDIM=C_CATEGORY
*FUNCTION TIMEDIM=TIME
*FUNCTION CURRENCYDIM=GROUPS
*FUNCTION ENTITYDIM=ENTITY
*FUNCTION ACCOUNTDIM=C_ACCT
*FUNCTION INTCODIM=INTCO
*FUNCTION DATASRCDIM=C_DATASRC //
This part is needed when a RATE cube
// is associated to the application //
(FX = single or multi currency) //
*FUNCTION THISAPP=CONSOLIDATE_1 -- My consolidation application
*FUNCTION RATEAPP=RATE1 ---New Rate Application consisting of in-built dimension.
*FUNCTION RATEENTITYDIM=RATESRC
*FUNCTION RATEACCOUNTDIM=RATE
*FUNCTION INPUTCURRENCYDIM=INPUTCURRENCY
*FUNCTION RATEENTITYMBR=RATEINPUT
*FUNCTION RATESRCCALCMBR=RATECALC
*FUNCTION AVGRATEID=AVG
*FUNCTION ENDRATEID=END
The modified FXTRANS.LGF (In the application) looks like :
//============================================= //
Currency translation logic //
*INCLUDE SYSTEM_CONSTANTS.LGL
*SYSLIB SYSTEM_LIBRARY.LGL
*SYSLIB MULTICURRENCYTRANS.LGL
*RUN_PROGRAM
CURR_CONVERSION CATEGORY=%C_CATEGORY_SET%
CURRENCY=%INPUTCURRENCY_SET%
TID_RA=%TIME_SET%
OTHER=ENTITY=%ENTITY_SET%
RATEENTITY=Global
*ENDRUN_PROGRAM
*COMMIT
I am facing 2 situations where I am getting errors:
1. While executing the package - Error --> Mapping error; the dimension does not exist in the application. CATEGORY
2. While validating the FXtrans.lgf/Default.lgf - Error --> "Invalid line in logic section : category = %C_categoy_set% invalid line in logic section"
I have referred the threads mentioned below but still unable to resolve this issue as this is the first time I am working on SAP BPC so I don't know much about this tool!
Invalid Dimension Entity in lookup
invalid-dimension-salesaccount-in-lookup-rule
Can somebody show me the right path..
Thanks
SG