OBIEE 11g: Unintended Whitespace Gets Inserted When Executing Logical Date/String Functions

(Doc ID 2296618.1)

Last updated on AUGUST 14, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.160719 and later
Information in this document applies to any platform.

Symptoms

 Suppose the result of CAST(CURRENT_DATE AS CHAR) function is "YYYY/MM/DD" (e.g. 2017/01/01), the result of the function below should be "YYYYMMDD" (e.g. 20170101).

SUBSTRING(CAST(CURRENT_DATE AS CHAR) FROM 1 FOR 4)||SUBSTRING(CAST(CURRENT_DATE AS CHAR) FROM 6 FOR 2)||SUBSTRING(CAST(CURRENT_DATE AS CHAR) FROM 9 FOR 2)

 However, the result of the function displayed in an analysis is "201701 01".
 And when exporting the analysis to CSV, the result of the function is exported as "201701 01                                                      01".

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms