My Oracle Support Banner

OBIEE 12C : VA Does Not Export All Rows If Data Contains Special Character ( e.g ‘#’.) (Doc ID 2271481.1)

Last updated on AUGUST 09, 2018

Applies to:

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

Symptoms

On : Oracle Business Intelligence Enterprise Edition 12.2.1.1.0 version, Visual Analyzer in FireFox Browser , 

VA Does not export all rows in report results when data contains special character (e.g. #)

Issue can be verified with below steps : 

1. Build a VA project based A - Sample Sales subject area (SampleApps RPD)
2. Add a filter on T03 Per Name Qtr, add a pivot with the following column: T03 Per Name Qtr, C56 Postal Code, C54 State Code and 1. Revenue in values
3. Export Data from this report (everything will be ok)
4. Add a calculation that concatenates Postal code, State code and ‘#’
"A - Sample Sales"."Cust Regions"."C54 State Code"||'#'||"A - Sample Sales"."Cust Regions"."C56 Postal Code"
5. Add this new column in the visualization and try to export data => only the first row will be exported.

Changes

NA 

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!


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