Oracle Communities

Oracle Analytics and AI

Child Item

In OAC Report column value of complete length is not coming

Indra Sardana-Oracle

Summary:

In OAC report column values are expected like :

Antigua and Barbuda

Bosnia and Herzegovina

Central African Republic

Equatorial Guinea

Ecuador

Where as in OAC report column values are coming :

Antigua

Bosnia

Central

Equator

Ecuador

Whereas in database in table column is defined as Varachar2(200) and values are present like :

Antigua and Barbuda

Bosnia and Herzegovina

Central African Republic

Equatorial Guinea

Ecuador

Any Input what could be possible reason.

Find more posts tagged with

Analysis

Accepted answers

All comments

Wayne Van Sluys

check the column in the RPD.

Indra Sardana-Oracle

In RPD also column is Varchar

Wayne Van Sluys

in each layer check that the column does not have a formula. Check in Physical Layer that it is querying same column in DB that you expect and do show values on that column

Anirban Basu-133546

Hi Indra ,

Can you get the session query of the OAC report and run the same in DB and check what is the output for that column

thanks

Anirban

Bharath Raghupathi-Oracle

Hi Indra,

One possibility is In the Physical layer check the column datatype length. It might be defined as varchar(7) as we are seeing only the first 7 characters.

Thanks,

Bharath

Sahithi Kolasani-Oracle

Agree with Bharath. Please check the column datatype length in RPD.

Indra Sardana-Oracle

Thanks Bharath and Sahithi and Wayne

Issue was with column length defined at physical layer it was Varchar2(7) instead of Varchar2(200)

Regards,

Indra Sardana