This discussion is archived
1 Reply Latest reply: Jan 29, 2013 4:01 AM by 978031 RSS

concatenating two columns in obiee 11g

978031 Newbie
Currently Being Moderated
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"

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points