5 Replies Latest reply on Apr 29, 2013 6:37 PM by VidyaS

    Two presentation hierarchial columns in single pivot view

      Hello Gurus,

      We have a requirement to setup a hierarchy (level based) within OBIEE11g for Work Orders. We have created a dimensional hierarchy for this Work Order and currently we have 3 level being used in this hierarchy.

      Level 1 ---~Level 2~
      ----------------------~Level 3~

      Also the users are looking to have these level descriptions drilled automatically in the Level Description columns when they drill on these Levels. We have tried this by setting up this these level descriptions as level keys in this work order hierarchy and use two hierarchical columns in one pivot view so that we can have level and also they would drill their corresponding descriptions without adding a filter to the report.

      But I guess there is a limitation with usage of hierarchical columns in OBIEE 11g that only one could be used in a report.

      Could anyone point me to any approach to resolve this issue ? Below is the expected output format.

      Level 1--10000034     5.1.3 - Lockwood Estates Main Extension
      Level 2-- 10000187     210 blow service replacement
      Level 3 -- 10000188     Renew Service

      Would appreciate any response on this.

      Thanks in advance.


      Edited by: VidyaS on Jan 14, 2013 2:42 PM