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

Last updated on SEPTEMBER 28, 2016

Applies to:

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

Symptoms

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.

Example:

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

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