OBIEE 12c Version 12.2.1.4, error for 5 numeric columns where 1 column is appearing as 0 in analytic

3527846

Hi Team,

I am using OBIEE 12c Version 12.2.1.4 with Vertica 9.2 database. I have a table in Vertica database details of which are as quoted herewith :

create table TEST_OBIEE_FACT (

dim_fk numeric,

c1 numeric,

c2 numeric,

c3 numeric,

c4 numeric,

c5 numeric);

grant select on TEST_OBIEE_FACT to OBIEE;

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

insert into TEST_OBIEE_FACT(dim_fk, c1, c2, c3, c4, c5) values (1, 1, 2, 3, 4, 5);

commit;

I am able to connect my OBIEE 12c environment successfully with Vertica database but when I try to import this table's data in my 12c environment, for 5 columns, 1 column is appearing 0

I tried to test it for Vertica driver which is passing the entire data correctly to OBIEE environment but for some unknown reason into the OBIEE 12c analytics environment, out of 5 columns 1 column's value is appearing as 0

Please can you look into this.

Thanks in anticipation.

Best Regards/Vivek

Joel

Vertica does provide an ODBC driver and can you confirm that you followed these instructions- https://www.vertica.com/kb/Vertica-Integration-with-OBIEE-Connection-Guide/Content/Partner/Vertica-Integration-with-OBIE…