OBIEE 12C : VA Does Not Export All Rows If Data Contains Special Character ( e.g ‘#’.)
(Doc ID 2271481.1)
Last updated on FEBRUARY 19, 2019
Applies to:
Business Intelligence Suite Enterprise Edition - Version 12.2.1.1.0 and laterInformation 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.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |