This discussion is archived
5 Replies Latest reply: Apr 29, 2013 11:37 AM by vidyas RSS

Two presentation hierarchial columns in single pivot view

vidyas Explorer
Currently Being Moderated
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.

Levels---Descriptions
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.

Vidya.

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points