Skip to Content
0
Former Member
Dec 02, 2009 at 06:14 AM

.LGF Modification Error

53 Views

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