4 Replies Latest reply on Jul 25, 2017 5:52 AM by Christian Berg

    Obiee Multiple Fact Report Question


      Hello obiee gurus,


      I am an obiee expert, and I always question points that I do not understand clearly. So here is one of my ambiguity :S


      It's about multiple fact reports. I know obiee content logic, it is important for multiple fact reports, so I set content level for all defined dimensions then I can create the report as I want. However, this case requires a strict fact table design. It must include only measure columns and dimensional columns (which joins a physical dimension table). What is the core reason under this obiee content logic? Is this same for different reporting tools such as cognos, ms strategy etc. (I've never used them)? Is this a powerful side of obiee, or not? I realy want to be clear :S


      Thank you four your attention.




        • 1. Re: Obiee Multiple Fact Report Question

          Well, if you have two facts and you want to combine them, then they need to contain the same set of dimensions. Imagine you have two facts - cars and people. Cars have a num_wheels dimension and people have a hair_colour dimension. It makes no sense to report how many people have four wheels!!


          You can actually combine facts at different dimensionality though using the FILTER clause. See here: Combining Facts/Subject Areas in Oracle OBIEE - Part 2 - Beyond Blog

          • 2. Re: Obiee Multiple Fact Report Question
            Christian Berg

            OBI at ist core is a source agnostic query Generator for any source there is.


            Logical dimensions and Logical Facts are - as their "Logical" bit of the Name implies - actually completely artificial concepts and have Zero to do with the physical model in the strictest sense of the word. I can happily and easily create a 10 fact, 30 Dimension model where only 4 dims will ever be conformed on one single flat file.


            You must comprehend this to comprehend why OBI does things the way it does them.


            a) all business model concepts are virtual

            b) don't even think "this Logical Dimension just means a dimension table" - through multiple LTSs and multiple tables nested inside each LTS I can create you a "Dimension" which - while a logical entity - is sourced from 20 physical sources, 2 being tables, 4 being cubes, 11 being XML and 3 coming from Hadoop


            Yes this is the strongest feature of the NQuire Server which people still don't get comprehend 20 years after its inception.

            • 3. Re: Obiee Multiple Fact Report Question
              Thomas Dodds

              Every fact has a dimensional context


              Every dimensional attribute is related through a fact (conformed dimensions & implicit facts)


              Use of information drives fact star design (typically a related set of business questions are answered by a single fact star)


              + to Christian Berg


              ^ the basic rules

              • 4. Re: Obiee Multiple Fact Report Question
                Christian Berg

                True, but contrary to breathing and heartbeat they don't happen automagically