Variables for Texts 
Variables for Texts
Definition
Variables are parameters of a query that are set in the query definition and are not filled with values (processed) until the query is inserted into a workbook. They act as placeholders for characteristic values, and are processed with any processing type other than authorization.
Use
As a rule, you use text variables in combination with variables for characteristic values. If you use a characteristic value variable in the structure element of the query definition, then it is recommended that you set up a text variable for the text. Define the text variable so that it is based on the characteristic with the characteristic value variable, and uses the processing type replacement path.
You can use text variables in all text fields of the query definition (query name, structure name and structure element name)
see also: Creating Queries with Variables).In order to define a variable for text, maintain the following detail statements depending on the processing type:
Enter the characteristic that has the value you want to replace the text with. Choose whether the text variable should be replaced by the from or the to value and the key or the name of the characteristic value. With the offset start and offset length, you can establish the start and length of the text output.
You want to create a text variable for the fiscal year. You select the key for the display and establish the offset start with value 2 and offset length as 2. The fiscal year is four digits; the output of the value begins on the third digit and shows 2 digits. Therefore, in the executed query, the text variable for fiscal year 1997 is replaced by the value "97".
Decide whether you want to able to modify the text variable when you insert the query. Choose Ready for Input if you want the variable to be ready for input before you insert the query into the workbook. With the processing type manual entry / default value, you can enter a default value for the text.
Enter the required text length. The text length determines the number of characters that are available when you insert the query into the workbook, to enter text manually or to modify the suggested text.
If you choose ready for input, you do not have to enter a default value for the text variable.
See also:
Maintaining Variables Delivered Variables