1 Reply Latest reply on Apr 13, 2017 10:22 AM by Gianni Ceresa

    OBIEE 12C: Issue with Table Owner Prefixed in Query

    2753252

      HI Gurus,

       

      We are facing an issue while fetching the SQL query for OBIEE 12c custom report Query.

       

      In the query, the physical table is getting prefixed with table schema owner name. (i.e. <xxx>.<table_name> on the other hand 11g OOB report’s query , we are not facing such issue, the table name is not getting prefixed with schema name.

       

      11g :- WITH SAWITH0 AS (select T577898.DAY_DT as c1 from W_DAY_D T577898 /* Dim_W_DAY_D_Common */ ) select D1.c1 as c1, D1.c2 as c2

       

      from ( select 0 as c1, D1.c1 as c2 from SAWITH0 D1 order by c2 ) D1 where rownum <= 65001 12c WITH SAWITH0 AS (select distinct T292.ADDR1 as c1 from D_CUST_DETAILS_TBL T292)

       

      select D1.c1 as c1, D1.c2 as c2 from ( select 0 as c1, D1.c1 as c2 from SAWITH0 D1 order by c2 ) D1 where rownum <= 65001

       

      12C: WITH SAWITH0 AS (select distinct T157.LEVEL1 as c1 from OFSATOMIC.DIM_COMMON_COA_MASTER T157) select D1.c1 as c1, D1.c2 as c2 from ( select 0 as c1, D1.c1 as c2 from SAWITH0 D1 order by c2 ) D1 where rownum <= 65001

       

      Any pointer to how to eliminate schema owner name(OFSATOMIC) adding in 12c query.

       

      Please help us on this issue.

       

      Thanks,

      Srikanth