Skip to Content
0
Former Member
Jun 29, 2009 at 04:34 PM

test script logic file - Errror "Invalid Dimension Account"

38 Views

Hi BPC Experts,

I am a new bee in BPC and have developed HCM applicaton in BPC 5.1. The Appset contains Finance, Rate & HCM applications.

I am working on HCM and wants to write a script logic file for HCM and it is giving an ERROR "Invalid Dimensin Account".

I have following dimensions in HCM Application:

account_hc --> type A

category_hc --> type C

company_hc --> type E

time_hc --> time t

costcenter_hc --> type u

datasrc_hc --> type d

employerole_hc --> type u

geography_hc --> type u

rptcurrency_hc --> type r.

I had defined Dimensions in system_cnstants file as mentioned below.

// application constants

//----


*FUNCTION CATEGORYDIM =CATEGORY_HC

*FUNCTION TIMEDIM =TIME_HC

*FUNCTION CURRENCYDIM =RPTCURRENCY_HC

*FUNCTION ENTITYDIM =COMPANY_HC

*FUNCTION ACCOUNTDIM =ACCOUNT_HC

*FUNCTION INTCODIM =INTCO

*FUNCTION CATEGORYDIM =CATEGORY

*FUNCTION TIMEDIM =TIME

*FUNCTION CURRENCYDIM =RPTCURRENCY

*FUNCTION ENTITYDIM =ENTITY

*FUNCTION ACCOUNTDIM =ACCOUNT

// This part is needed when a RATE cube

// is associated to the application

// (FX = single or multi currency)

//----


*FUNCTION THISAPP =HCM

*FUNCTION RATEAPP =RATE

*FUNCTION RATEENTITYDIM =RATESRC

*FUNCTION RATEACCOUNTDIM =RATE

*FUNCTION INPUTCURRENCYDIM =INPUTCURRENCY

*FUNCTION RATEENTITYMBR =RATEINPUT

*FUNCTION RATESRCCALCMBR =RATECALC

*FUNCTION AVGRATEID=AVG

*FUNCTION ENDRATEID=END

I tried to validate and save standard default script logic. But it gives me an error " NO match defined for lookup dimension Category"

So I could not use default logic file to write my script logic. Hence I have created HCM logic file. and Given the following script logic.

*XDIM_MEMBERSET ACCOUNT = XYZ_INC_RetPlan

*WHEN ACCOUNT

*IS XYZ_INC_RetPlan

*REC(FACTOR = 1.1, ACCOUNT)

*ENDWHEN

*COMMIT

While validat & save, I get an error "Invalid Dimension Account".

I do not understand why these errors occuring.

I have checked Category & Account dimensions checked. Every thing is ok. I have created Input schedules and they are working ok. It means the dimensions are fine.

Then why the error ?

Can you guys please guide me.

Appreciate your kind help.