One-level dimensions consist of the specification of a key and an optional description.
The syntax for specifying formatting instructions for a one-level dimension is as follows:
[<Prefix>]VAL[<Separator>][DESC][<Postfix>]
or
[<Prefix>]DESC[<Separator>][VAL][<Postfix>]
Specifying a prefix and postfix allows you to make the parameter list more descriptive. The specified strings must also be contained in the filter value specifications.
If no formatting instructions are specified, the following default instructions are used:
Format |
Value |
Interpretation |
DESC (VAL) |
GERMANY (DE) |
Description = GERMANY, key = DE |
VAL |
DE |
Key = DE, no description |
When using the default formatting instructions, the filter value specification GERMANY (DE) is interpreted as the value DE and the description GERMANY. The filter value specification Screw M12 is interpreted as the value Screw M12 with no description, as the separator ( does not appear in the value.
When using the default formatting instruction DESC (VAL) a space is specified as the separator between the description and the key, which has to be replaced by the character %20 or %#32 when transferring parameters using a URL.
Examples
PRINCIPAL=GERMANY (DE);BRAZIL (BRA);UNITED KINGDOM (UK)
PRINCIPAL=DE;BRA;US
VTWEG(VAL,DESC)=10,End customer sales;12,Resellers
PRINCIPAL(Value: 'VAL', Description: 'DESC')=
Value: 'DE', Description: 'GERMANY';
Value: 'BRA', Description: 'BRAZIL'
A separator of your choice must be used between the formatting instructions VAL and DESC as these formatting instructions would not otherwise be recognized.