My Oracle Support Banner

OBIEE/Visual Analyzer : Incorrect data returns when the data type length is not correctly defined (Doc ID 2696927.1)

Last updated on AUGUST 13, 2020

Applies to:

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

Symptoms

On : 12.2.1.4.0 version, Analytics

ACTUAL BEHAVIOR
---------------
Correct values are not getting uploaded in OBIEE report when dataset is uploaded through visual analyzer

An issue has been observed in a dashboard after the data was uploaded for the same in visual analyzer.
There is a difference in the Asset Number being uploaded in the excel sheet and  what is visible on the dashboard.

The total records are 186245 in excel file when uploaded through visual analyzer whereas 186186 assets are available on the dashboard.

On analyzing , it has been found that a certain column value with prefix: 'XYZ' is not coming in proper format.
Eg: "XYZ-111111-11" is appearing as "XYX-111111" in OBIEE report. The value after hypen is not coming in the report.

Therefore, it is being counted as one though there are many rows with prefix : XYZ-111111 in data set.


Additionally:
After checking the OBIEE logs it is found that there is an XML code in log in which datatype for this specific column is Varchar(11) whereas the length of the column value for the missing records in uploaded file is 14.

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