Skip to Content
avatar image
Former Member

BPC 7.5 NW - DIM UserDefined in PROMPT when using Formule in Package ?

Hi, we try running ScriptLogic from Package using /CPMB/DEFAULT_FORMULAS inside button by VBA.

Application.Run "MNU_eTools_DATAMANAGER"
Application.Run "MNU_eData_RUNPACKAGE"

Application.Run "MNU_eDATA_SELECTPACKAGE", "Prueba", "/CPMB/DEFAULT_FORMULAS", "Company", "Financial Process"

The firts problem is the obligatory for PROMPT:

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%")

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,COPIA.LGF)

We reduce only for Category and working good, but is posible disable PROMPT ?

I try comment but code the ScriptLogic not working.

'PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%")

The second problem is when need request user_defined dimension in PROMPT, is posible ?

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 30, 2010 at 08:18 AM

    Hi,

    I thought you can still use ' to comment out the statement as in the MS version. In NW, I dont remember exactly. As suggested, you can definitely try //

    Coming to your next statement, You can definitely use user defined dimensions also. CATEGORY_DIM is just a alias name for your dimension. Instead of using CATEGORY_DIM, you can directly use the name of the dimension.

    PROMPT(SELECTINPUT,,,,"CATEGORY,TIME,ACCOUNT")

    Please note that there are no % signs around the dimension name. The dimensions names are separated by commas. And the entire list of the dimension names is enclosed within double qoutes. I have mentioned 3 dimension names for example. You can have other dimensions also.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 29, 2010 at 10:58 PM

    // works as comment in DM packages like in Scripts. You'd have to comment out (or delete) lines with PROMPT and TASK for SELECTION.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 01, 2010 at 02:57 PM

    Hi,

    nilanjan chatterjee

    Hi,

    In your script, you have the statement,

    *XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

    This means that the script is expecting some value to come from the DM package. So you need to have the prompt statement to pass that value from DM to the script.

    Hope this helps.

    Thank you, i know and is good for other peoples read this post.

    I define the points for you, in relation to Post Topic and previous answer :

    Hi,

    I thought you can still use ' to comment out the statement as in the MS version. In NW, I dont remember exactly. As suggested, you can definitely try //

    Coming to your next statement, You can definitely use user defined dimensions also. CATEGORY_DIM is just a alias name for your dimension. Instead of using CATEGORY_DIM, you can directly use the name of the dimension.

    PROMPT(SELECTINPUT,,,,"CATEGORY,TIME,ACCOUNT")

    Please note that there are no % signs around the dimension name. The dimensions names are separated by commas. And the entire list of the dimension names is enclosed within double qoutes. I have mentioned 3 dimension names for example. You can have other dimensions also.

    Hope this helps.

    -


    Now, Ethan Jewett

    Hi,

    Does the following actually work for you?

    PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%")

    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,COPIA_PCC.LGF)

    I don't think it will, because there is nothing assigned to the %SELECTION% variable.

    Yes, this working for me in NW 7.5 SP03, is default code when make new DM package using "/CPMB/DEFAULT_FORMULAS"

    Other point is for use HIER NODE in PROMPT for send to ScriptLogic code.

    I need close this post and set points, then open this post for speak the "use HIER NODE in PROMPT for send to ScriptLogic code"

    BPC 7.5 NW - HIER NODE in PROMPT using Formule in Package ?

    Thank you.

    Add comment
    10|10000 characters needed characters exceeded