Skip to Content

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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.