BPC Error: “No members found in dimension “TIME” for condition “CALC” = “N”

[Former Member]

Hello Experts,

We got an error message in QA: “No members found in dimension “TIME” for condition “CALC” = “N” after we added new properties( YEAR6 to YEAR20) to  "VERSION"  Dimension. And we also mantain the Time Dimension, adding new members from 2019 to 2033 which are related to VERSION property.

We also found there is one year "2020" occurs error when we saved data( The default logic has been modified corresponded). There is no problem when I check all the master data.

But when I run the script, this error message shows up. I also valided the same script logic in Production(master data has not been modified). It also shows this error message.

I am not sure this error related to master data or not. Could you please help and share your experience? Thank you in advance!

BPC Version: 10.0 SP 15 Patch1 .NET3.5

Regards,

Tyler

[Former Member · Accepted solution]

Hello experts,

Thank you for your help!

This issue has been fixed by applied SAP note 2003100(script logic couldn't be validated in HANABPC).

Hope this can help if you have the same issue!

Regards,

Tyler

[former_member186338]

Sorry, but where is the script text???

Vadim

P.S. "BPC Version: 10.0 SP 15 Patch1 .NET3.5" - it's not a BPC version, it's EPM version and it's terribly old!

[Former Member]

Thank you, Vadim!

We are using BPC 10.0 NW.

I thought there is no issue with script, so I did not put the text on.

In production, we did not modify any script. When we valid a script logic, also get this error message.

Here is the script in QA:

*WHEN SUP_DMD
*IS LS

//*SELECT(%SLR_GRP%,[SLR_GRP],RC, "ID=%RC_SET%")
*SELECT(%SLR_GRP%,[ID],RC,"[ID]=#####")
*SELECT(%LD_CLIENT%,[CLIENT],RC, "ID=%RC_SET%")

*WHEN DATA_TYPE
*IS FTE

*WHEN TIME

// YEAR1 - Monthly
*IS BAS(%YEAR1%.TOTAL)

// LS Monthly Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]),DATA_TYPE = HOURS)
// LS Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR1%.12]),DATA_TYPE = DOLLARS)

*WHEN RT
*IS 010
//LS SVHO Monthly Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]),DATA_TYPE = SVHOHRS)
//LS SVHO Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO])* ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR1%.12]),DATA_TYPE = SVHODOL)
//LD SVHO Monthly Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]), RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = HOURS)
//LD SVHO Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO])* ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR1%.12]),RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = DOLLARS)

//LD SVHO Monthly FTE
*REC(FACTOR = ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]), RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = FTE)
*ENDWHEN

// YEAR2 - Monthly
*IS BAS(%YEAR2%.TOTAL)

// LS Monthly Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]),DATA_TYPE = HOURS)
// LS Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR2%.12]),DATA_TYPE = DOLLARS)

*WHEN RT
*IS 010
//LS SVHO Monthly Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]),DATA_TYPE = SVHOHRS)
//LS SVHO Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO])* ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR2%.12]),DATA_TYPE = SVHODOL)
//LD SVHO Monthly Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]), RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = HOURS)
//LD SVHO Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO])* ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR2%.12]),RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = DOLLARS)
//LD SVHO Monthly FTE
*REC(FACTOR = ([FAC].[SVHO_MONTHLY],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]), RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = FTE)
*ENDWHEN

// YEAR3 - Annual
*IS %YEAR3%.12

// LS Annual Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]),DATA_TYPE = HOURS)
// LS Annual Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR3%.12]),DATA_TYPE = DOLLARS)

*WHEN RT
*IS 010
//LS SVHO Annual Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]),DATA_TYPE = SVHOHRS)
//LS SVHO Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO])* ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR3%.12]),DATA_TYPE = SVHODOL)
////LD SVHO Monthly Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]), RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = HOURS)
////LD SVHO Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO])* ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR3%.12]),RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = DOLLARS)
////LD SVHO Monthly FTE
*REC(FACTOR = ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]), RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = FTE)
*ENDWHEN

// YEAR4 - Annual
*IS %YEAR4%.12

// LS Annual Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]),DATA_TYPE = HOURS)
// LS Annual Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR4%.12]),DATA_TYPE = DOLLARS)

*WHEN RT
*IS 010
//LS SVHO Annual Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]),DATA_TYPE = SVHOHRS)
//LS SVHO Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO])* ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR4%.12]),DATA_TYPE = SVHODOL)
////LD SVHO Monthly Hours
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]), RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = HOURS)
////LD SVHO Monthly Dollars
*REC(FACTOR = ([FAC].[BASE_HOURS],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[HOURS],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND]) * ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO])* ([FAC].[SLR],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[DOLLARS],[RC].[%SLR_GRP%],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[TIME].[%YEAR4%.12]),RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = DOLLARS)
////LD SVHO Monthly FTE
*REC(FACTOR = ([FAC].[SVHO_ANNUAL],[LOCAL_USE].[NO_LOCAL],[PROJ].[NO_PROJECT],[DATA_TYPE].[PERCENTAGE],[RC].[NO_RC],[CLIENT].[NO_CLIENT],[REVISION].[NO_REVISION],[SUP_DMD].[NO_SUPPLY_DEMAND],[RT].[LBR.REGLBR.SAVHO]), RT = 126, CLIENT = %LD_CLIENT%, PROJ = 00000, LOCAL_USE = 00000, SUP_DMD = LD, DATA_TYPE = FTE)
*ENDWHEN

       -----------------------------Rest of script just repeat the YEAR4 till to YEAR 20---------------------------------
*ENDWHEN
*ENDWHEN
*ENDWHEN

[former_member186338]

This is not a full script:

Variable %YEAR1% is not defined etc...

Please perform at least some troubleshooting yourself! Reduce the script size and find the line generating error!

Vadim

[Former Member]

Hi Tyler,

What error message you are getting in script logic. Please check is there any dump in ST22.

Best Regards,

Deepak

[Former Member]

Hi Deepak,

Thank you for help!

The error message is “No members found in dimension “TIME” for condition “CALC” = “N”. And there is no dump when I check in ST22.

Regards,

Tyler