Skip to Content
0
Former Member
Mar 22, 2012 at 08:03 PM

RUN LOGIC:Invalid Dimension

97 Views

We are getting the following error when running the script logic below...

RUN LOGIC:Invalid Dimension:"DATATYPE].[VOL" in Application: "REVENUE" Failed

We were able to successfully run the script in QA, but once we went to Production, we get the error above. The dimension and dimension member referenced in the error do exist.

We are currently on BPC 7.5 NW SP6 Patch1. Any help would be appreciated.

//ADDED KWH_TAX to XDIM_MEMBERSET UNIT 09/28/2011

// Derive Revenue from RATE & VOLUME Recs

// Select Cal Month based on property of Rel Flag

*Select(%CALMO%,ID,TIME,"[REL_FLG]=Y")

// Select Cyc Month based on property of Rel Flag

*Select(%CYCMO%,ID,CYCLE_MONTH,"[REL_FLG]=Y")

// Select Rate Schedules based on property of Rel Flag

*Select(%RSC%,ID,RATE_SCHEDULE,"[REL_FLG]=Y")

// Select Baseline records from REVENUE application.

//NOTE: This script will NOT validate "as is" due to the TARIFF value being passed from the user selection within the DataManger package.

*XDIM_MEMBERSET DATA_SOURCE = RATE_INP

*XDIM_MEMBERSET FCST_YEAR AS %YR% = SELF($SELECTION$)

*XDIM_MEMBERSET CYCLE_MONTH = %CYCMO%

*XDIM_MEMBERSET TIME= %CALMO%

*XDIM_MEMBERSET DATATYPE = RATE

//*XDIM_MEMBERSET BILLNG_LINE_ITEM = <all>

*XDIM_MEMBERSET CUST_CLASS = <all>

*XDIM_MEMBERSET PRICE_BLOCK = <all>

*XDIM_MEMBERSET UNIT = TOT_KWH_DELV, KWH_TAX, PLS, TOT_KWH_NONSHOP, TOT_KWH_NONSHOP_FXD

*XDIM_MEMBERSET RATE_SCHEDULE = GLOBAL_RATE

*XDIM_MEMBERSET VERSION AS %VER% = SELF($SELECTION$)

*XDIM_MEMBERSET TARIFF AS %TAR% = SELF($SELECTION$)

// Select Company based on property of TARIFF

*Select(%CO%,COMP,TARIFF,"[ID]=%TARIFF_SET%")

*XDIM_MEMBERSET COMPANY = %CO%

*Select(%BL%,STATE,COMPANY,"[ID]=%CO%")

*XDIM_FILTER BILLNG_LINE_ITEM = [BILLNG_LINE_ITEM].properties("%BL%") = "Y"

// Multiply Factor from GL and derive the cal month, new datasource

*WHEN COMPANY

*IS *

*FOR %RS%=%RSC%

*REC(EXPRESSION=%VALUE%*([DATA_SOURCE].[VOL_INP],[BILLNG_LINE_ITEM].[BILL_DETER],[DATATYPE].[VOL],[RATE_SCHEDULE].[%RS%]),RATE_SCHEDULE=%RS%,DATA_SOURCE=REV_OUT,DATATYPE=REV_2)

*NEXT

*ENDWHEN