Concatenating in Designer--Not quite solved yet

building semantic layer
1

Original question:
<I need to combine 2 numbers from 2 different objects with a “/” in between to represent a month/year value.

I can easily do this in BO User Reporting mode using + “/” + . Is there some way to define an object by combining objects with character strings in Designer?>

Many thanks to all who gave me suggestions. The “||” does work for concatening objects (yes, we use Oracle), but the parse regards my “/” as an invalid column name. Is is possible a character other than quotes defines a string in Oracle-based Designer?

-Beverly

Listserv Archives (BOB member since 2002-06-25)

2

The following SQL parsed OK in Designer (I’m on Oracle 7.3 and BO 4.1.3). I don’t think the “/” is the problem. Try using single quotes instead of double quotes.

rtrim(PATIENT.LAST_NAME) || '/ ’ || rtrim(PATIENT.FIRST_NAME) || ’ ’ || rtrim(PATIENT.MIDDLE_NAME)

George Baranowski
QuadraMed

Listserv Archives (BOB member since 2002-06-25)