Advanced script issue??

[former_member225916]

Hi All,

We are using BPC NW 10.0 and EPM add-in 10.0 SP 20 .NET4.

Below is my advanced script to clear comments.I am taking entity and time dimensions to select and fixing FORECAST AND 2015.02.

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

PROMPT(RADIOBUTTON,%ENABLETASK%,"Do you want to clear comments associated with data regions?",1,{"Yes","No"},{"1","0"})

INFO(%SUFFIX1%,DIMENSION:VERSION|FORECAST|)

INFO(%SUFFIX2%,DIMENSION:TIME|2015.02|)

TASK(/CPMB/CLEAR_COMMENTS,SELECTION,%SELECTION%%SUFFIX1%%SUFFIX2%)

TASK(/CPMB/CLEAR_COMMENTS,ENABLETASK,%ENABLETASK%)

TASK(/CPMB/CLEAR_COMMENTS,CHECKLCK,%CHECKLCK%)

I am getting "Invalid selection criteria" error while running below code without %SELECTION% variable (i.e commenting SELECTINPUT prompt) and removing the %SELECTION% variable from TASK(/CPMB/CLEAR_COMMENTS,SELECTION,%SUFFIX1%%SUFFIX2%) task.

'PROMPT(SELECTINPUT,%SELECTION%,,,"%ENTITY_DIM%,%TIME_DIM%")

PROMPT(RADIOBUTTON,%ENABLETASK%,"Do you want to clear comments associated with data regions?",1,{"Yes","No"},{"1","0"})

INFO(%SUFFIX1%,DIMENSION:VERSION|FORECAST|)

INFO(%SUFFIX2%,DIMENSION:TIME|2015.02|)

TASK(/CPMB/CLEAR_COMMENTS,SELECTION,%SUFFIX1%%SUFFIX2%)

TASK(/CPMB/CLEAR_COMMENTS,ENABLETASK,%ENABLETASK%)

TASK(/CPMB/CLEAR_COMMENTS,CHECKLCK,%CHECKLCK%)

Can I run the package with fixed members using INFO command (for fixing the members)??

Thanks and Regards,

Naidu

[dinesh_veluru · Accepted solution]

Hi Naidu,

please check the below thread.

Thanks,

Dinesh.V

[former_member186338]

Isn't it strange:

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

...

INFO(%SUFFIX2%,DIMENSION:TIME|2015.02|)

...

TASK(/CPMB/CLEAR_COMMENTS,SELECTION,%SUFFIX1%%SUFFIX2%)

Duplication of TIME dimension???? %TIME_DIM% and %SUFFIX2%

Vadim

[former_member225916]

Hi Vadim,

actually i was supposed to remove time dimension from SELECTINPUT. (it's not complete code).

I got answer from Dinesh.

Thanks,

Naidu