Error in Script logic!!

[Former Member]

Hi Experts,

We are using BPC 7.5 SP04, The below Push to Finance logic is giving error message "Error in ProcessSQL: Subscript out of range" if executes for pair having one TimeID eg:“MYP/30202/2012.Dec”  but if we submit the value for more than time period in one submission eg: some value for pair “MYP/30202/2012.Dec” and some value for “MYP/30202/2012.Nov” then we will not see this error.

Please Advice!!

Thanks & Regards,

Rohit

***START OF LOGIC***

//=============================================

// Push to Finance logic

//=============================================

*INCLUDE SYSTEM_CONSTANTS.LGL

*XDIM_MEMBERSET ASSETCLASS=<ALL>

*XDIM_MEMBERSET CAPEXTYPE=<ALL>

*FLAG_PERIOD = CATEGORY.CURRMO

// Retrieve all of the reporting currencies in order to send converted currencies to Finance

*SELECT(%REPORTING_CURRENCIES%, "[ID]", "RPTCURRENCY", "[REPORTING] = 'Y'")

// Add the reporting currencies to the members being pushed

*XDIM_MEMBERSET RPTCURRENCY=LC,%REPORTING_CURRENCIES%

*DESTINATION_APP = Finance

*SKIP_DIM= CapexType,AssetClass

*ADD_DIM DATASRC=CapexApp

*RENAME_DIM CapexAccount=Account

//*CLEAR_DESTINATION

*WHEN CATEGORY

*IS <> "ACTUAL"

    *WHEN POS(TIME)

    *IS >POS(%FLAG_PERIOD%)

        *REC(Factor=1)

    *ENDWHEN

*ENDWHEN

*COMMIT

***END OF LOGIC****

[Former Member]

Hello Rohit,

Try to use *GO instead of *COMMIT.

Please refer to:

1408315 - Usage of *GO and *COMMIT in script logic

Hope it helps.

Regards,

Vin

[Former Member]

Hi Vin,

Thanks for your reply, Using *GO instead of *COMMIT does not make any difference.

Thanks & Regards,

Rohit