Problem concatinating strings

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  August 18, 2003 at 4:35 am

  #106979

  Hi all,

  I have a dimension Time: Year/Quarter/Month.

  For the quarter it displays only a number (1,2 and 3)

  Member name column:{fn QUARTER("AAW"."ABPA_C903_CY"."POSTING_DATE")}

  It's more readable when there's a text saying "Quarter 1"...

  So I tried CONCAT('Quarter',:{fn QUARTER("AAW"."ABPA_C903_CY"."POSTING_DATE")})}

  but received an error: Column is not valid.

  This has something to do with the driver I'm using (Oracle). Is there a solution to overcome this error and when displayed I see "Quarter 1"...

  Thanks in advance.

  Kind Regards,

  Bart

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  August 18, 2003 at 6:02 am

  #470248

  Hi Bart,

  have you tried the concatenation operator of || (pipe pipe)?

  So your formula would be

  'Quarter ' || {fn QUARTER("AAW"."ABPA_C903_CY"."POSTING_DATE")}

  If this doesn't work, do you need to specify the Concat function as a function like you have with the Quarter function? (ie use {fn CONCAT(....)} )

  Hope this helps.

  Steve.

  Steve.

• BEIJCKM

  Mr or Mrs. 500

  Points: 583

  More actions

  September 12, 2003 at 12:34 pm

  #473979

  Hi Steve,

  Thanks for your info.

  It worked !

  Regards,

  Bart