1 Reply Latest reply: Feb 6, 2013 3:17 AM by Satya Ranki Reddy RSS

    Why we need to create hierarchy for every dimension

    User769078-Oracle
      Hi,

      Hierarchy creation for every dimension is best practice in OBIEE. What are the uses of them.

      Thanks,
      Anilesh
        • 1. Re: Why we need to create hierarchy for every dimension
          Satya Ranki Reddy
          Hi,

          As per my knowledge there are certain reasons /requirements purpose, we are going to build hierarchy.

          1. perform aggregate navigation,
          2. configure level-based measure calculations,
          3. users from Dashboard and Answers to drill down from one parent to a child level.


          In future if you want use time series function in project , you have to build time hierarchy in rpd.

          Time Series function like (Todate,Ago,Period Rolling)..

          Note: Hierarchy creation for every dimension is best practice .

          Hope this help's

          Thanks
          Satya