Offset for Text Variables

The following example shows the settings that can be made for text variables using processing type Replacement Path with replacement from a characteristic in terms of the properties Replacement With (key or external attribute of the key) together with Offset Start and Offset Length.

The following table shows the internal and external display of the key for the characteristic values fiscal year variant K4 and fiscal year/period 2002/008 without offset settings:

Table 1: Internal and External Display of the Key without Offset Settings
Replacement With	Fiscal Year 0FISCYEAR	Fiscal Year / Period 0FISCPER
Internal display (key)	K42002	K42002008
External display (external characteristic value of the key)	K4/2002	K4/008.2002

Internal Display (Key)

Fiscal Year 0FISCYEAR

If you want to replace K42002 with 2002 in the query, you have to set the offset start to 2 and the offset length to 4 for the characteristic fiscal year 0FISCYEAR.

Fiscal Year/Period 0FISCPER

If you only want to display the year in the text output, set the offset start to 2 and the offset length to 4. In the query, K42002008 is replaced by 2002.
If you want to display the year and period in the text output, set the offset start to 2 and the offset length to 7. In the query, K42002008 is replaced by 2002008.

The following table illustrates how you can influence the internal display of the key for the characteristic values fiscal year variant K4 and fiscal year/period 2002/008 using offset settings:

Table 2: Internal Display of the Key with Offset Settings
Characteristic	Offset Start	Offset Length 4
0FISCYEAR	Offset Start 2	Offset Length 4
0FISCPER	Offset Start 2	Offset length 4 for year Offset length 7 for year and period

External Display (External Characteristic Value of the Key)

Fiscal Year 0FISCYEAR

If you want to replace K4/2002 with 2002 in the query, you have to set the offset start to 3 and the offset length to 4.

Fiscal Year / Period 0FISCPER

If you want to display only the year in the text output, set the offset start to 7 and the offset length to 4. In the query, K4/008.2002 is replaced by 2002.
If you only want to display the period in the text output, set the offset start to 3 and the offset length to 3. In the query, K4/008.2002 is replaced by 008.
If you want to display the year and period in the text output, set the offset start to 3 and the offset length to 8. In the query, K4/008.2002 is replaced by 008.2002.

The following table illustrates how you can influence the external display of the key for the characteristic values fiscal year variant K4 and fiscal year/period 2002/008 using offset settings:

Table 3: External Display of the Key with Offset Settings
Characteristic	Offset Start	Offset Length 4
0FISCYEAR	Offset Start 3	Offset Length 4
0FISCPER	Offset length 7 for year Offset start 3 for period Offset start 3 for year and period	Offset length 4 for year Offset length 3 for period Offset length 8 for year and period