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

[former_member247531]

Hello All,

I am getting the below error while validating/execute the below script

when i execute the below script I am getting "No members found in dimension “TIME” for condition “CALC” = “N” "

//Moving Salary Effect date to Current period+1 for Existing Employees

*XDIM_MEMBERSET JOBLEVEL = NO JOB LEVEL
*SELECT(%CC%,[ID],COSTCENTER,COMPANY_CODE = %COSTCENTER_SET%)

*XDIM_ADDMEMBERSET COSTCENTER = C35009000

*XDIM_MEMBERSET ACCOUNT = NO_ACCT
*XDIM_MEMBERSET ACCOUNT_EMP = SALARY_EFF_DATE
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET DATASRC = MANUAL
*XDIM_MEMBERSET CATEGORY = WE
*XDIM_MEMBERSET EMPLOYEE = E300509,NoEmp
*XDIM_MEMBERSET TIME = 2021BASE
%CUR_PER% = 2021.01
%TIME% = 2021
%DEC_PER% = 2021.12

*WHEN ACCOUNT.GL_SL_RP

*IS $CHK$ *REC(EXPRESSION=(%CUR_PER%==%DEC_PER%)?0:(%VALUE%<TMVL(1,%CUR_PER%))?(%VALUE%>0)?(TMVL(1,%CUR_PER%)):%VALUE%:%VALUE%) *ENDWHEN
*COMMIT Can you please help.For your reference, i have attached the BW/BPC version and Time dimension.Thanks.Srikanth time.png version.png

[former_member186338]

Sorry, but what do you mean by the following lines???

*XDIM_MEMBERSET TIME = 2021BASE
%CUR_PER% = 2021.01
%TIME% = 2021
%DEC_PER% = 2021.12

It's not a script logic syntax...

Also strange member here:

*XDIM_MEMBERSET JOBLEVEL = NO JOB LEVEL

with spaces inside ID???

Please explain the logic you want to achieve!

[former_member247531]

Hello Vadim,

Thanks for your reply.

below is the actual script.

And Yes, Job level ID is like this only in our dimension .NO JOB LEVEL

and script is to move the salary effect date to Current period+1 for all Existing Employees

*XDIM_MEMBERSET JOBLEVEL = NO JOB LEVEL
*SELECT(%CC%,[ID],COSTCENTER,COMPANY_CODE = %COSTCENTER_SET%)
*XDIM_ADDMEMBERSET COSTCENTER = %CC%
*XDIM_MEMBERSET ACCOUNT = NO_ACCT
*XDIM_MEMBERSET ACCOUNT_EMP = SALARY_EFF_DATE
*XDIM_MEMBERSET RPTCURRENCY = LC
*XDIM_MEMBERSET DATASRC = MANUAL
*XDIM_MEMBERSET CATEGORY = WE
*SELECT(%EMP%,[ID],EMPLOYEE,COST_CENTER = %COSTCENTER_SET%)
*SELECT(%EMP_CC%,[ID],EMPLOYEE,COST_CENTER = %CC% )
*XDIM_MEMBERSET EMPLOYEE = %EMP_CC%,NoEmp
*XDIM_MEMBERSET TIME = %TIME_SET%
*SELECT(%CUR_PER%,[BEGIN_PER],TIME,ID = %TIME_SET%)
*SELECT(%TIME%,YEAR,TIME,[ID] = %TIME_SET%)
*SELECT(%DEC_PER%,ID,TIME,YEAR = %TIME% AND PERIOD = DEC)

*WHEN ACCOUNT.GL_SL_RP *IS $CHK$ *REC(EXPRESSION=(%CUR_PER%==%DEC_PER%)?0:(%VALUE%<TMVL(1,%CUR_PER%))?(%VALUE%>0)?(TMVL(1,%CUR_PER%)):%VALUE%:%VALUE%) *ENDWHEN
*COMMIT

[former_member186338]

*SELECT(%CUR_PER%,[BEGIN_PER],TIME,ID = %TIME_SET%)

Does it mean that %TIME_SET% contain only single period when you run this script?

In your TIME dimension screenshot I can't see property BEGIN_PER

Provide some example!

Create a simple Excel table to show required logic.

The whole script have to be rewritten.

[Marc_Kuipers]

Hello srikanth_bpc

See:

https://answers.sap.com/questions/11946417/bpc-error-%E2%80%9Cno-members-found-in-dimension-%E2%80%9...

Marc

[former_member186338]

Sorry, but the mentioned link have no relation to the question asked...

[Marc_Kuipers]

Sure it does