5 Replies Latest reply on Jun 27, 2018 10:58 AM by Christian Berg

    BI questions

    Robeen

      Hi,

       

      I would like to know how BI works in simple terms and as a database administrator what would be my role?

       

      Regards,

       

      Joe

        • 1. Re: BI questions
          Christian Berg

          Hi Robeen,

           

          You will need to be more specific than that since the BI stack is pretty much the most diverse and complex one that Oracle has.

           

          Do you mean architecture? Servers?

          • 2. Re: BI questions
            Robeen

            Hi Christian,

             

            I would like to know about the architecture how BI works

             

            Regards,

             

            Joe

            • 3. Re: BI questions
              Christian Berg

              Have you already looked at the documentation?

              And MOS Doc 2067527.1 ?

               

              There is quite a lot of information out there from Oracle as well as other sources

              1 person found this helpful
              • 4. Re: BI questions
                Gianni Ceresa

                Robeen wrote:

                 

                ....as a database administrator what would be my role?

                 

                Your role? Sit down and enjoy your coffee

                As a DBA from a BI point of view you don't really have an active role as long as your BI developers know their job. In a more realistic situation you will probably have to help diagnose slow queries and find out if by adding indexes or partitioning could help. Just keep in mind a detail: OBIEE doesn't execute queries written by somebody, the tool generate the queries based on a model. So as a DBA do not reply something like "add this hint or change your query to be like that" as often it's quite difficult if not impossible to force the tool in generating a query exactly as you want it (still possible but not easy).

                • 5. Re: BI questions
                  Christian Berg

                  Hahahaha not toally wrong :-)

                   

                  Hadn't properly read that part so Gianni's point is extremely valid: If you have good OBI people then you yourself - as a DBA - you won't have much to do at all