Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Former Member
Former Member replied

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.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question