Command Wizard 

Use

The Command Wizard helps you when you use the Button design item to create pushbuttons in the BEx Analyzer. You can use the wizard for the following command options:

Workbook-Specific Command

Wizard Option	Static Parameters: Name	Static Parameters: Value
Process Variables	CMD	SHOW_VARIABLE_SCREEN
Display Personalized Variables	PERSONALIZED	X
Toggle Drag and Drop	CMD	TOGGLE_DRAGDROP
Disable Drag and Drop	CMD	DISABLE_DRAGDROP
Allow Drag and Drop	CMD	ALLOW_DRAGDROP

●      With the Process Variables command you can call the dialog box for selecting variable values and change those values. You can also display personalized variables.

●      With the Drag&Drop commands you can activate or deactivate this function or you can toggle between the active and non-active status.

Planning-Specific Command

Wizard Option	Static Parameters: Name	Static Parameters: Value
Save	CMD	SAVE_AREA
Transfer Values	CMD	VALUE_CHECK
Execute Planning Function	CMD	EXECUTE_PLANNING_FUNCTION
Planning: Execute Sequence	CMD	EXEC_PLANNING_SEQUENCE
Reset Area	CMD	RESET_AREA
Refresh	CMD	REFRESH_AREA

●      Using the Save command, you can persistently store changes to transaction data. If the check is successful, the changed data is written to the InfoCube or InfoCubes.

●      Using the Transfer Values command, you can copy changed data from an input-ready query to the planning buffer. The entries are checked when this is done. If the check is successful, the data is copied across.

●      Using the Execute Planning Function command, you can trigger the execution of a planning function. The dialog box that appears in the subsequent step allows you to select the planning function and data provider. You can either select the planning function or branch to the planning modeler where you can create or edit a planning function. If the planning function contains variables, the system displays these variables in the lower area of the dialog box. Input help is available for selecting the values. By selecting a data provider, you specify from which data provider (with type filter or query view) the selection for all characteristics is to be made. When you choose Finish, the system copies the values for PLANNING_FUNCTION_NAME and DATA_PROVIDER_FILTER to the button properties.

●      Using the Execute Planning Sequence command, you can trigger the execution of a planning sequence. A dialog box for selecting the planning sequence then appears. You can either select the planning sequence or branch to the planning modeler where you can create or edit a planning sequence. If the planning sequence contains variables, the system displays these variables in the lower area of the dialog box. Input help is available for selecting the values. When you choose Finish, the system copies the values for PLANNING_SEQUENCE_NAME to the button properties.

●      With the Reset Area command you can reset all entered planning data that you have not yet saved.

●      With the Refresh command you can request current data from the BI system and thus refresh the data in the workbook. You can also use this command to refresh data in workbooks that are not specific to planning.

You can also specify variables for the variable values contained in the function or sequence for the commands Execute a Planning Function and Execute a Planning Sequence. For more information, see Transferring Variable Values.

By choosing OK in the Button Properties dialog box, you complete the editing process for the pushbutton. If required, you can add additional functions to the button properties by choosing Create. This allows you to specify that the execution of a planning function is to be followed by the execution of a planning sequence.

Data-Provider-Specific Command

You first select the required data provider. In the subsequent step, you can choose the following options:

Wizard Option	Static Parameters: Name	Static Parameters: Value
Edit	CMD	SET_INPUT_MODE
Display	CMD	SET_INPUT_MODE
Filter Command	CMD
Assign Query/Query View	CMD	RESET_DATA_PROVIDER

●      Using the Edit and Display commands, you can specify the mode for data entry. 

○       If you select the Edit option, you can use this pushbutton to switch to change mode for an input-ready data provider.

○       If you select the Display option, you can use this pushbutton to switch to display mode for an input-ready data provider.

●      If you select the Filter Command option, a dialog box for selecting the dimension appears, assuming this is supported by the selected data provider.

●      If you choose the Assign Query/Query View option and select the required query, the system copies the values for INFOCUBE and QUERY to the button properties.