3 Replies Latest reply on May 19, 2017 4:19 PM by Christian Berg

    OBIEE Look Up query generation

    Phantasm

      Hi - I have witnessed that OBIEE sometimes generates a separate query for the look up function and sometimes it stitches the the look up query with the main query as inner or left outer (based on look up). Could you pls tell me how does OBIEE decides that or is there any way to control it.

       

      Any pointers on this would be of great help.

       

      Thanks

        • 1. Re: OBIEE Look Up query generation
          Christian Berg

          Hi,

           

          There's a huge number of things playing a role there

          a) DENSE vs SPARSE

          b) How and where is the LOOKUP used

          c) Is the lookup table in the same physical layer parent as the calling object

          d) Or is there even a jump across technologies necessary (e.g. Essbase cubes doing lookups in DB tables or XML files doing lookups in Hadoop)

          e) What kind of functions and functionalities does the data source support (or data source*S*)

          f) What DB features are enabled in the RPD (not what can the source do but what do you allow it to do)

          g) Is there some post-calculation required

          h) Does the model itself do things like snowflaking or framenting (and you basically kick in with the lookup after those facts)

          etc

           

          Impossible to tell you precisely what is what without actually sitting in front of your solution

          • 2. Re: OBIEE Look Up query generation
            Phantasm

            Hi Christian - Thanks for your reply, so is it fair to assume that based on the code/solution that we have implemented OBIEE engine will decide by itself how to generate the query for look up and it can't be influenced by any parameter settings in OBIEE (excluding point no f).

             

            Just to add to the info the scenarios i was talking about were all within Oracle database and were simpler like fetching descriptions based on ID's from look up tables. There were no cross technologies reporting or fragmentation. I should have mentioned these in my original post.

             

            My main intention was to confirm if there is any specific setting or parameter which can enforce separate/ stitched queries for lookups.

             

            Thanks,

            • 3. Re: OBIEE Look Up query generation
              Christian Berg

              No "one parameter", no. Sorry.