OBIEE-与基因的语法错误

Question

我正在将以下代码作为OBIEE分析中字段公式的编辑，但返回错误。有什么想法吗？

SUBSTRING("Dim - Vendor Header"."Dock Time", 
LOCATE(':',"Dim - Vendor Header"."Dock Time")+1, 
  (CHAR_LENGTH("Dim - Vendor Header"."Dock Time") - 
LOCATE(':',REVERSE("Dim - Vendor Header"."Dock Time")) - 
LOCATE(':',"Dim - Vendor Header"."Dock Time")))

错误如下：

Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message 
returned from OBIS. [nQSError: 27002] Near <)>: Syntax error [nQSError: 
26012] .Please have your System Administrator look at the log for more 
details on this error. (HY000)
SQL Issued: SET VARIABLE DISABLE_CACHE_HIT=1; SELECT Substring ("Dim - 
Vendor Header"."Dock Time", LOCATE(':',"Dim - Vendor 
Header"."Dock Time")+1) FROM "XHSS - Vendor"
OK (Ignore Error)

Answer 1

obiee12c中是否有任何函数字符串反向？您可以通过仅在公式下方提供以下一部分来尝试，然后检查相同的错误正在遇到...

(char_length(" dim -dim -vendor header"。" dock time"( - locate('：'，rectervers(" dim - - 供应商header"。" dock time"((