Function documentationSELECTINPUT Prompt() Command Locate this document in the navigation structure

 

This command is used to allow the user to select only noncalculated members (for export, for example).

Syntax: PROMPT(SELECTINPUT, [variable], [second variable], [label], [dimensions])

Where

Means

Default Value

SELECTINPUT

Select one noncalculated data range

n/a

[variable]

The name of the returned variable

%SELECTION%

[label]

The text to display to the user.

Enter your selection

[dimensions]

The dimensions from which to select members

Category, Time, Entity

Activities

%DIMS% is the dimension list in the current application. The value can be ACCOUT, ENTITY, TIME. %SELECTION% is the result that the user selects in the Run Package dialog box.

PROMPT(SELECTINPUT,,,,"%DIMS%")

%SELECTION% is the result that the user selects in the Run Package dialog box. The script can be the following:

PROMPT(SELECTINPUT,%SELECTION%,,,"%DIMS%")

%DIMS% creates the screen, and the selected result is saved in %SELECTION%. Without %selection%, you use %SELECTION% as the default. Therefore, you can also write the script as PROMPT(SELECTINPUT,%ANYNAME%,,,"%DIMS%"), then use %ANYNAME% in the task commands.

Example

If you need only one SELECTINPUT prompt command, create the package script as follows:

PROMPT(SELECTINPUT,%SOURCEENTITY%,,"Enter Source Entity","%ENTITY_DIM%") TASK(/CPMB/ALLOCATION_LOGIC,SELECTION,%SOURCEENTITY%)

If you need more than one SELECTINPUT prompt command, create the package script as follows:

PROMPT(SELECTINPUT,%SOURCEENTITY%,,"Enter Source Entity","%ENTITY_DIM%")

PROMPT(SELECTINPUT,%TARGETENTITY%,,"Enter Target Entity","%ENTITY_DIM%")

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/ALLOCATION_LOGIC,TAB,%TAB%)

TASK(/CPMB/ALLOCATION_LOGIC,EQU,%EQU%)

TASK(/CPMB/ALLOCATION_LOGIC,REPLACEPARAM,ASARENT%EQU%%ASARENT%%TAB%SOURCE%EQU%%SOURCEENTITY%%TAB

%TARGET%EQU%%TARGETENTITY%)

TASK(/CPMB/ALLOCATION_LOGIC,MEMBERSELECTION,SOURCE%EQU%%SOURCEENTITY%%TAB %TARGET%EQU%%TARGETENTITY%)

You can hardcode the selection using INFO commands, as follows:

INFO(%DIMVALUE%,E=24)

INFO(%SELECTION%, /APP123/PLANNING/PrivatePublications/I045795/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:ENTITY|A1000|DIMENSION:CATEGORY||DIMENSION:TIME||)

INFO(%DIMVALUE%,E=24) means that 24 different entity members are selected in a group.

In the import package, the package_size specifies how large each group is. In the export, this value is used to specify the group to improve the export performance.

Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, except if such damages were caused by SAP intentionally or by its gross negligence.