0 Replies Latest reply: May 8, 2012 4:48 AM by MRERP2 RSS

    some performance problem with an answer (OBIEE10g)

    MRERP2
      Hello,

      I have some performance problem with an answer (OBIEE10g)
      The answer is on simple Business Area - simple star-schema with one db Connection.
      The answer has many fields.
      After adding fields from tables that already participating in the report, suddenly
      the SQL replace of one statement became two with a strange join between them with bad performance.

      .... nvl(D1.c8 , 'q') = nvl(D2.c6 , 'q') and nvl(D1.c8 , 'z') = nvl(D2.c6 , 'z') and D1.c12 = D2.c10 and nvl(D1.c14 , 'q') = nvl(D2.c12 , 'q') and nvl(D1.c14 , 'z') = nvl(D2.c12 , 'z') and nvl(D1.c9 , 'q') = nvl(D2.c7 , 'q') and nvl(D1.c9 , 'z') = nvl(D2.c7 , 'z') and D1.c15 = D2.c13 and nvl(D1.c10 , 'q') = nvl(D2.c8 , 'q') and nvl(D1.c10 , 'z') = nvl(D2.c8 , 'z')

      Maybe someone has an idea how to prevent it ?

      Thank you