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~
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.
Edited by: VidyaS on Jan 14, 2013 2:42 PM
Is there any way to use Level based hierarchies to get functionality like that of value based .? Reason being these dimensions are created of transaction views so not sure how to handle updates in the tables which are created when setting up parent child hierarchies.
Thanks for the reply Srini, the requirement here is to show all open work orders in form of hierarchy. The pivot should display all work order and attributes in levels like I have a work order hierarchy which are broadly categorized into three levels Lvl 1 > Lvl 2 > Lvl 3. I also have other attributes for these work orders like WO Desc, WO Type , WO SupWork Type for each levels i.e Level_1 WO Desc , Level_1 WO Type , Level_1 WO SubWork Type and so on.. ! Now the need is to create a report with this Work Order Hierarchial column and when expending this column levels the all the other attributes like WO Desc , WO Type and WO SubWork Type should be in a single column and expand along with these levels within these columns whenever the user clicks on the plus and minus signs in this hierarchial column.
I have my data for the attributes in in Level 1 WO Desc , Level 2 WO Desc and Level 3 WO Desc etc , how can I show this like we do in hierarchial column to expand along with Work Order Hierarchy.
Please let me know if you have any suggestions.