OBIEE 11g: Unintended Whitespace Gets Inserted When Executing Logical Date/String Functions
Last updated on AUGUST 14, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.160719 and later
Information in this document applies to any platform.
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).
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".
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