Special method

Function

The special method is an operation based on an SQL script set up by the configurator according to the project needs. In addition to the standard SQL, the special method supports CCH Tagetik system parameters, workspace parameters and reporting parameters. The use of special methods is recommended when performing operations that are more in-depth than standard CCH Tagetik operations.

System parameters supported in the operation syntax

The system parameters that are defined when the operation is performed are listed below:

Parameter	Description
System parameters	- See System parameters.
warning_message	(optional) Output variable which returns a warning message, to be used for special method operations with "Warning" outcome (the outcome is "Successful" by default)

Workspace parameters can be referred to using the syntax @PARAMETERCODE@ and reporting parameters can be referred to using the syntax ${@PARAMETER}.

Special method parameters

Customized parameters can be associated with the special method, and their values are defined in DTP settings. In particular, you can set parameters to select a dataset and a type on which to run the operation, or parameters that allow you to indicate a string. Parameters can refer to the body of the special method using the syntax &PARAMETERCODE& (see Parameters Pane).

To define the special method operation, the following parameters must be set :

• dataset and typology, for dataset/typology parameters
• a free field, for string parameters

Execution

For every Special Method, you can specify whether to disable concurrency checks. By default, an activity which contains at least one special method is run in isolation, i.e. disabling the activity's parallel data processing. By setting the "Deactivate concurrency check" flag, the user setting the parameters takes on responsibility for ensuring that the activity containing the special method can be run concurrently with other activities.