My Oracle Support Banner

OBIEE 11g Issue With Right Trim On Varchar Columns With Trailing Spaces (Doc ID 526914.1)

Last updated on NOVEMBER 18, 2019

Applies to:

Siebel Analytics - Version 7.5.1 [AN164] to [AN 7164] [Release V7]
Business Intelligence Suite Enterprise Edition - Version to [Release 10g to 11g]
All Platforms
This document was previously published as Siebel SR 38-988850551


A particular summary level report shows a correct sub-total, but when you look at the rows which make up the subtotal, the values do not add up to the total.

Have verified that the subtotal shown is correct, but the report appears to "hide" some data and is not adding those values to one of the rows, which makes up the subtotal.


A dimension column 'Product' contains strings, some of which have a trailing space as in this example:
Product               Dollars
'Bulk Barley'          3411
'Bulk Barley '           471

-Run a request in Answers, with a Grand Total.
-You will see one line only for 'Bulk Barley', with the Dollars for 'Bulk Barley'.
-The SQL query returns 2 lines, but the Analytics request returns 1 line.

The Grand Total, however is correct and includes the Dollars for ''Bulk Barley ' (with a Trailing space):
Product               Dollars
'Bulk Barley'          3411
Grand Total:         3782


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

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