1 Reply Latest reply: Jan 29, 2013 6:01 AM by 978031 RSS

    concatenating two columns in obiee 11g

    978031
      Hi,
      I am getting an syntax error when i concatenate two columns from the same table and i think syntax is correct.

      below is the column formula:

      (cast("Dim Stock Market"."Days High" as varchar))||'/'||(cast("Dim Stock Market"."Days Low" as varchar))

      error:

      Formula syntax is invalid.
      [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near <)>: Syntax error [nQSError: 26012] . (HY000)
      SQL Issued: SELECT (cast("Dim Stock Market"."Days High" as varchar))||'/'||(cast("Dim Stock Market"."Days Low" as varchar)) FROM "Stock Model"