Skip to Content

DM Package Error - 'More than one dimension in selection condition' - MEMBERSELECTION

Hi - Am currently working on to get Target Values from Multiple dimensions , similar to COPYINPUT command .

However, the DM Package failed with message ''More than one dimension in selection condition'

Here is my advanced Script.

PROMPT(SELECT,%SELECTION%,,"Selection 1,2,3","%CATEGORY_DIM%,%TIME_DIM%,SHOW") 
PROMPT(SELECTINPUT,%T_CAT%,%T_TIME%,%T_SHOW%,"%CATEGORY_DIM%,%TIME_DIM%,SHOW,") 
INFO(%EQU%,=) 
INFO(%TAB%,;) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%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,T_CAT%EQU%%T_CAT%%TAB%T_TIME%EQU%%T_TIME%) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,T_CAT%EQU%%T_CAT%%TAB%T_TIME%EQU%%T_TIME%%TAB%T_SHOW%EQU%%T_SHOW%) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,ZZTEST.LGF)


Please let me know, how to fix this and any other alternative solution.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Thanks Vadim. Will try and let you know.

    Regards

    Srini

    Add comment
    10|10000 characters needed characters exceeded

    • Nothing to test, it's just a standard syntax of SELECTINPUT:

      PROMPT(SELECTINPUT,%T_CAT%,,"Enter CATEGORY","%CATEGORY_DIM%")
      PROMPT(SELECTINPUT,%T_TIME%,,"Enter TIME","%TIME_DIM%")
      PROMPT(SELECTINPUT,%T_SHOW%,,"Enter SHOW","SHOW")
  • Hi Vadim - Have tried and is not allowing <all> values and getting message - Select Fewer members for at least one dimension

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 06:29 PM

    For sure this syntax is not supported:

    PROMPT(SELECTINPUT,%T_CAT%,%T_TIME%,%T_SHOW%,"%CATEGORY_DIM%,%TIME_DIM%,SHOW,")

    You need 3 prompts - one prompt for each variable!

    Please read help!

    https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.30/en-US/f9c652116faf1014878bae8cb0e91070.html

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19 at 08:58 PM

    If you are talking about badi (strange idea to copy using badi...) then you can use:

    PROMPT(COPYMOVEINPUT, %SOURCE%, %TARGET%, [label], [dimensions], [default members])

    You can pass SOURCE and TARGET "as is" using REPLACEPARAM and then you can parse variables inside badi

    Add comment
    10|10000 characters needed characters exceeded

  • Thanks Vadim . It works

    Srini

    Add comment
    10|10000 characters needed characters exceeded