Command Wizard 

Use

The Command Wizard provides helps when using the Button design item to create pushbuttons in 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 them. You can also display personalized variables.

●      With the drag & drop commands you can activate or deactivate this function, or 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. A dialog box appears where you can select the planning function and data provider. You can either select a planning function, or create or edit one by branching to the planning modeler.

If the planning function contains variables, the system displays these in the lower area of the dialog box. Input help is available for selecting the values.

By selecting a data provider, you specify which data provider (with type filter or query view) the selection for all characteristics is to be made from.

By selecting Process Changed Data (Parameter PROCESS_CHANGED_DATA) you can define that only data changed by the user in the current session since the last save will be processed (see Processing Changed Data in Planning Functions). If you choose this option, you can specify which aggregation level to analyze as a filter to define the changed records.

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 appears. You can either select a planning sequence or create or edit one by calling Planning Modeler.

If the planning sequence contains variables, the system displays these in the lower area of the dialog box. Input help is available for selecting the values.

As with the Execute Planning Function command, selecting Process Changed Data (parameter PROCESS_CHANGED_DATA) allows you to define that only data changed by the user in the current session since the last save will be processed (see Processing Changed Data in Planning Functions). If you choose this option, you can specify which aggregation level to analyze as a filter to define the changed records. After the planning sequence has been executed, all subsequently changed data counts as having been completed by all participating planning functions (the steps in this sequence). This means for example that the data created by the last step of a sequence does not count as changed if the first step is executed again. If a button that just starts a planning sequence, “Check the Changed Data" for example, is executed several times in quick succession, the system does not process any data for the repeat executions.

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. More information: 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

Select the required data provider. You can then make the following settings:

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.