Skip to Content
0
Former Member
Mar 12, 2014 at 10:34 AM

Logic Script Error - 42

30 Views

Hello Friends,

I am facing the logic script error when validating the script. "the script is apparently invalid, as you cannot have member "". The logic is run for grouped cost center.

Logic Script:

//***********************START OF HEADER*****************

//SUB QUERY:

//PURPOSE: Copy high Level forecast data from Actuals, Budget, commitments to base level cost centres defined for forecat

//CALLED FROM: Data Manager Package

//WHO: Matt Penston (itelligence)

//VERSION: 1

//DATE: 26-11-2012

//CHANGE LOG:

//***********************END OF HEADER********************

//

//

//********************** Need to first of all clear down the BW data in the base member costcentres ***************

// Set XDIM_MEMBERSET

*XDIM_MEMBERSET CATEGORY = Actual,Budget,COMMITMENTS

*XDIM_MEMBERSET AUDITTRAIL = BW

*XDIM_MEMBERSET ACCOUNT = <ALL>

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET ACCDETAIL = F_None

//Select Current Month Time Member to copy from

//*SELECT(%TIME_CURRMTH_FYA%,"[ID]","TIME","[FCST_PROFILES] = 'A'")

//*XDIM_MEMBERSET TIME = %TIME_CURRMTH_FYA%

*XDIM_MEMBERSET TIME = BAS(201314.TOTAL)//CHANGE ONCE PER YEAR

//Select CostCentres for high level Forecast entry

//*SELECT(%HL_FCST_ENT%,"[ID]",COSTCENTRE,"[HL_FCST_ENT] = 'Y'")

// Use For Loop to run through the Cost Centres

//*FOR %HL_FCST_FOR% = %COSTCENTRE_SET%

*XDIM_MEMBERSET COSTCENTRE = BAS(%COSTCENTRE_SET%)

//*SELECT(%HL_FCST_BASE%, "[ID]", COSTCENTRE, "[HL_FCST_PRNT] = %COSTCENTRE_SET%")

*SELECT(%HL_FCST_BASE%, "[HL_FCST_BM]", COSTCENTRE, "[ID]= %COSTCENTRE_SET%")

// Set the Ref Data to Transaction, is the default but defined anyway.

*WHEN_REF_DATA=TRANSACTION_DATA

*WHEN CATEGORY

*IS *

*REC(FACTOR=-1, AUDITTRAIL = BW_HL, COSTCENTRE = %HL_FCST_BASE%)

*REC(FACTOR=1, AUDITTRAIL = BW, COSTCENTRE = %HL_FCST_BASE%)

*ENDWHEN

//*NEXT

*COMMIT

The Error Came once validate above script:

Can anyone please guide the same.

Regards,

Dev.

Attachments

Logic_scritp.jpg (57.4 kB)