4 Replies Latest reply on Sep 5, 2018 12:54 PM by MichaelRm

    OBIEE12: Problem to create an (dense)analysis with a logical SQL

    MichaelRm

      Hi,

      I need to create an analysis and I want to make a dense extraction to display all rows of a dimension. I could do that within the repository design but this decrease considerably the performance.

      Ive written a logicial SQL that does the trick and this SQL works perfectly within the Issue SQL in administration panel!

       

       

      But If I try to create a new analysis with I get this error:

       

       

      Error generating view. Error getting cursor in GenerateHead

        Error Details

      Error Codes: OAMP2OPY:KNYNDVB7

      Invalid SQL Identifier: (SELECT 0 s_0,......

       

       

      I cant understand what Im doing wrong... how can I handle this behavior ?

       

       

      here is how the SQL looks like:

      SELECT  s_0,s_1, ..

      FROM

      (

      SELECT

         s_0, s_1, ...

      FROM "Case Event"

      WHERE

        ...conditions...

      ) A --sql I've copy-past from another analysis

        RIGHT OUTER JOIN

      (

      SELECT

         s_0, s_1

      FROM "Case Event"

      WHERE

      ...conditions...

      ) D --dimension I want dense

      ON ( A.s_0 = D.s_0 AND A.s_1 = D.s_1  )

      ORDER BY ...

      FETCH FIRST 200001 ROWS ONLY