![]() Previous |
![]() Next |
The concatenation operator (||
) combines text expressions.
'The date today is: ' || sysdate
generates a text string such as The date today is: 23-AUG-06
.
The next example concatenates the level name and dimension keys of the Product dimension to create an identifier.
PRODUCT.LEVEL_NAME || ' ' || PRODUCT.DIM_KEY
Level | Dim Key | Identifier |
---|---|---|
CLASS | HRD | CLASS HRD |
FAMILY | DTPC | FAMILY DTPC |
FAMILY | MON | FAMILY MON |
FAMILY | MEM | FAMILY MEM |
FAMILY | MOD | FAMILY MOD |
FAMILY | DISK | FAMILY DISK |
FAMILY | LTPC | FAMILY LTPC |