Script logic CATEGORY source and CATEGORY target with Package

[former_member606751]

Hi Experts,

I would like to know if it's possible when writting a script logic to use the Category dimension as %CATEGORY_SET% and select the member through a package ?

The requirement is to copy one category into another category.

The script logic developed for this purpose is the following :

*XDIM_MEMBERSET CLIENT_FINAL = Z00001

*XDIM_MEMBERSET DEVISE = EUR

*XDIM_MEMBERSET DOMAINE_FONC = G35208

*XDIM_MEMBERSET PARTENAIRE = S9999

*XDIM_MEMBERSET SOCIETE = SAE

*XDIM_MEMBERSET PRODUIT_PROG = SN_Z

*XDIM_MEMBERSET VT_CR = VTOFFICIELLE_CR

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET% --> Source Category

*XDIM_MEMBERSET TEMPS = BAS(2017.TOTAL)

*XDIM_MEMBERSET SOURCE_DONNEES = SAISIE_DI, REPART_AJUST_DI, AJUST_CENTRAL, AJUST_DIV *WHEN CATEGORY

*IS *

*REC(FACTOR = 1, CATEGORY = %CATEGORY_SET%) --> Destination Category

*ENDWHEN

Kind regards

SAP BPC 11.1

[former_member186338 · Accepted solution]

Sorry, but why not to search??? I have answered the question about MEMBERSELECTION hundreds of times..

PROMPT(SELECTINPUT,%SELECTION%, ,"Enter Source CATEGORY","%CATEGORY_DIM%") 
PROMPT(SELECTINPUT,%TARGETCATEGORY%, ,"Enter Target CATEGORY","%CATEGORY_DIM%")
INFO(%TAB%,;)
INFO(%EQU%,=) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,TARGETCATEGORY%EQU%%TARGETCATEGORY%)
INFO(%KEYDATE%,)
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,LOGICFILENAME,XXXXXXX.LGF) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,KEYDATE,%KEYDATE%)

In script logic use

*REC(FACTOR = 1, CATEGORY = $TARGETCATEGORY$) 

[former_member606751 · Accepted solution]

Thanks a lot Vadim.

I'm closing the post.

Kind regards

[former_member606751 · Accepted solution]

Hi Vadim,

sorry to bother you, I'd like to know if it's possible to use prompt COPYMOVEINPUT and passed 2 or more dimensions in source and target ?

It's OK with SELECTINPUT but for user experience, it's better to have one screen selection rather than 2 screens selection.

Thanks for your help again.

King Regards.

[former_member186338 · Accepted solution]

shak_khan

You can use COPYMOVEINPUT, but for single dimension only.

And you have to pass both COPYMOVEINPUT variables using MEMBERSELECTION

If you need to select other dimension members - use separate SELECTINPUT with SELECTION variable.

[former_member186338]

In your DM advanced script you have to add second SELECTINPUT prompt to select target CATEGORY into some variable.

Then, using TASK MEMBERSELECTION you can pass this variable to the script logic (for example $TARGET_CATEGORY$)

[former_member606751]

Thanks Vadim for your answer,

Could you provide a syntax example of TASK MEMBERSELECTION

Kind regards