2 Replies Latest reply: Jul 11, 2013 6:12 AM by a0db9043-8615-4dc2-abe4-ca7e06d72b7a RSS

    Issue with Skip Level Hierarchy in OBIEE 11g

    ram_rpb
      Hi,

      I have implemented Ragged and Skip Level Hierarchy as explained in the links below in OBIEE 11g RPD.
      (checked the 'Ragged' and 'Skipped Levels' check boxes)

      http://www.rittmanmead.com/2010/07/obiee-11gr1-support-for-ragged-skip-level-value-based-hierarchies/
      http://docs.oracle.com/cd/E17904_01/bi.1111/e10540/dimensions.htm#BABFBBFG

      When the Presentation Hierarchy is dragged in the OBI Answers, the leaf level beyond the skip (null) levels is not shown in the report.
      When any level finds intermediate null values, OBIEE is failing to show the existing value of the leaf level (Most Granular Level) or any values after Skipped Levels.

      For example, following is the values in database for different levels of department hierarchy.
      A -> B -> C -> Null -> Null -> F

      The OBIEE Presentation Hierarchy can only drill down till C, not beyond that. (does not show the leaf level value 'F').

      Could you please suggest whether I am missing any step?

      Thanks.