4 Replies Latest reply on Sep 26, 2015 4:42 AM by Otgontugs Miimaa

    Show all dimension table rows [left/right outer join]

    Otgontugs Miimaa

      Hi Gurus,

       

      https://community.oracle.com/message/9807768

       

      there is a method to show all dimension table rows in analysis even they is no matching rows in joined fact table. When i try to test it, following error is given. Anybody know why?

      created a table as following

      create table dummy as select 1 col1 from dual;

      and in physical layer joined this dummy table to D1 with complex join on 1=1 condition.

      In BLL just join D1 and DUMMY by inner join.

      In answers just put columns DUMMY.col1, D1.id, F1.id.

       

      You may be able to evaluate this query if you remove one of the following column references: D1.FID, D1.ID, DUMMY.COL1, F1.FK1, F1.ID (HY000)

      Error Codes: :U9IM8TAC:OI2DL65P

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 14025] No fact table exists at the requested level of detail: [,,[D1.FID],,,[F1.FK1, F1.ID],[DUMMY.COL1]]. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: D1.FID, D1.ID, DUMMY.COL1, F1.FK1, F1.ID (HY000)

      SQL Issued: SELECT 0 s_0, "GB"."D1"."COL1" s_1, "GB"."D1"."FID" s_2, "GB"."D1"."ID" s_3, "GB"."F1"."FK1" s_4, "GB"."F1"."ID" s_5 FROM "GB" FETCH FIRST 65001 ROWS ONLY

       

      Thanks in advance