1 Reply Latest reply on Apr 3, 2019 11:10 AM by Joel Acha

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

    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