How to get the target selection in logic script from COPYMOVEINPUT prompts

[Former Member]

Hi All,

Can I use COPYMOVEINPUT prompts with multiple dimensions selection? I created a data manager package using process chain "/CPMB/DEFAULT_FORMULAS". I am using COPYMOVEINPUT prompts in the dynamic script. It is as follows.

PROMPT(COPYMOVEINPUT,%SELECTION%,%TOSELECTION%,"Select the members to MOVE and where to", "TIME,CATEGORY,ACCOUNT,ENTITY)

I am calling a logic script to do some processes. Is there a way or variable where I can get the target members (TOSELECTION) that are being selected from the logic script?

Thank you in advance for all the help.

[former_member186338 · Accepted solution]

Hi Xin,

Please look help for SELECTINPUT, there is a description how to work with variables using MEMBERSELECTION TASK.

B.R. Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks for the reply. I am using COPYMOVEINPUT in order to copy data from one source to a new target. I want to make the selections in one screen. There is no way for us to get the target members (TOSELECTION) from the logic script?

Thank you.

[former_member186338 · Accepted solution]

Hi Xin,

I have already explained you that using TASK MEMBERSELECTION you can pass members selected in the %TOSELECTION% variable to script logic. Please, provide the script logic text to see what you want to achieve.

B.R. Vadim

[Former Member · Accepted solution]

Hi Vadim,

I did try with TASK MEMBERSELECTION. It is working if I use one dimension in COPYMOVEINPUT prompt.

Now I have multiple dimensions in the COPYMOVEINPUT prompt. Following is my script:

PROMPT(COPYMOVEINPUT, %SELECTION%, %TOSELECTION%, "TEST","TEST_AOS_DEAL_ID,TEST_AOS_ID,TEST_AOS_PARTNER,TEST_AOS_STATUS,TIME")

INFO(%EQU%,=)

INFO(%TAB%,;)

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

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

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

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

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,SELECTION%EQU%%SELECTION%%TAB%TOSELECTION%EQU%%TOSELECTION%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%) 

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,TEST.LGF)

I am not sure how are we going to call the selections by the users for all the dimensions in logic script.

I got the following error if I run the above script:

[Message]

--------------------------------------------------------------

More than one dimension in selection condition

model: TEST_AOS. Package status: ERROR

Sorry, I am not really good in BPC. Appreciate your help.

[former_member186338 · Accepted solution]

Hi Xin,

I am asking you to post not the DM advanced script but the TEST.LGF file to understand what you want to do: "Please, provide the script logic text to see what you want to achieve."

Vadim

[former_member186338 · Accepted solution]

By the way, it's not possible to pass 2 variables like %SELECTION% containing multiple members of multiple dimensions to the script logic in lgf file. Only one SELECTION can be passed using:

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

And in the lgf file the contents of this variable will become an initial script scope. The unique dimension members can be accessed in the script using the SET variables, like %DIMNAME_SET%.

It means that you can use COPYMOVEINPUT to specify members of only one dimension.

Vadim

[Former Member · Accepted solution]

Hi Vadim,

I have not write any logic script yet in the TEST.LGF file as I am thinking how to pass the selections. You have answered my doubts. Thank you very much for the information.

[former_member186338 · Accepted solution]

Hi Xin,

Before passing selections you have to define what you want to do in the script... Then the required user prompts can be configured! COPYMOVEINPUT is used in the COPY/MOVE chains that can accept 2 SELECTION parameters with multiple dimensions:

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

TASK(/CPMB/CM_CONVERT,TOSELECTION,%TOSELECTION%)

For DEFAULT_FORMULAS_LOGIC only 1 SELECTION parameter is available:

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

B.R. Vadim