Error Script Logic Central Execution (with Data Manager)

[former_member182305]

Hello Experts,

I am trying to run a Script Logic using Data Manager and I get the error that MEMBERS are not Valid for Dimension.

My Script Logic is the next (I want to calculate the Budget based on REAL):

*XDIM_MEMBERSET CATEGORIA = Real

*XDIM_MEMBERSET MONEDA= MXN

*XDIM_MEMBERSET SOCIEDAD= 1000,1010,1020, 1021,1030,1040,1041,1050,1051,1052

*XDIM_MEMBERSET ZRELACIONCTACEBE= NA_ZREL

*XDIM_MEMBERSET PERIODO= %PERIODO% <-----------------------------Here I also tried (%TIME_DIM%) with my TEST 2

*WHEN O_CTAS.IND

  *IS HIS

  *REC(FACTOR= 10, SOCIEDAD=1010, CATEGORIA=Sugerido)

*ENDWHEN

TEST 1

And the code I have in the Data Manager is as next:

PROMPT(SELECTINPUT, %PERIOD%   ,  ,"PERIODO","%TIME_DIM%")

TASK(/CPMB/ICDATA_LOGIC,SUSER,%USER%)

TASK(/CPMB/ICDATA_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/ICDATA_LOGIC,SAPP,%APP%)

TASK(/CPMB/ICDATA_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/ICDATA_LOGIC,LOGICFILENAME,PRESUPUESTO.LGF)

TEST 2

And the code I have in the Data Manager is as next:

PROMPT(SELECTINPUT ,,,,"%TIME_DIM%")

TASK(/CPMB/ICDATA_LOGIC,SUSER,%USER%)

TASK(/CPMB/ICDATA_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/ICDATA_LOGIC,SAPP,%APP%)

TASK(/CPMB/ICDATA_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/ICDATA_LOGIC,LOGICFILENAME,PRESUPUESTO.LGF)

With my TEST 1 I got that the error that the condition is not valid. With the TEST 2 I get the error Thate the Members for Dimension PERIODO are not Valid.

What am I doing wrong.

Thanks for the Posts.

Regards.

[former_member186338 · Accepted solution]

TEST2   is more or less correct, but the script logic has to be:

*XDIM_MEMBERSET PERIODO= %PERIODO_SET%

[former_member186338 · Accepted solution]

In TEST2 you can also use:

PROMPT(SELECTINPUT ,,,,"PERIODO")

you can use real dimension name in the advanced script or the name of the dimension type like %TIME_DIM%

P.S. It's also a good idea to close the previous discussion

[former_member182305 · Accepted solution]

Thank you very much Vadim.

It worked.

[former_member186338 · Accepted solution]

Even TEST1 can be corrected, but you have to delete line with SELECTION and add line with MEMBERSELECTION and some INFO. Look help for BPC 7.5