My Oracle Support Banner

OBIEE 11g: Unintended Whitespace Gets Inserted When Executing Logical Date/String Functions (Doc ID 2296618.1)

Last updated on MARCH 14, 2019

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).

 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".

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.