Page 24 - DCAP606_BUSINESS_INTELLIGENCE
P. 24

Unit 2: Multidimensional Analysis




          2.2.1 Type of Hierarchy                                                               Notes

          Level-based: This type of hierarchy consists of an ordered set of two or more levels.


                 Example: A time hierarchy might have three levels for Year, Quarter, and Month.
          Level-based hierarchies can also contain parent-child relationships. This type of dimension
          hierarchy levels allow to perform aggregate navigation and configure level-based measure
          calculations.
                               Figure 2.2: Level based Hierarchy Example



























































          Source: http://gerardnico.com/wiki/_media/dat/obiee/bi_server/design/dimension/
          obiee_multiple_dimension_hierarchie.jpg




                                           LOVELY PROFESSIONAL UNIVERSITY                                   19
   19   20   21   22   23   24   25   26   27   28   29