OBIEE11g: Analysis / Report Column/Field Drill-down Issue

To ensure that all Level-based Hierarchies created at .rpd level work properly, make sure not to include lower-level column/field in the report or in "Exclude" section in Layout.

• i.e: if you have a Level-based Hierarchy in this order: Product > Brand > Type > Product_Name; and you are creating and analysis with Brand to drill-down as needed, DO NOT include Type or Product_Name. 
• This happens, because even though you may put Type or Product_Name in "Exclude" section, the BI server will take as "not to show," since it is excluded.