What you're describing is the way the product works. If you don't like that then use Visual Analyzer - that drills differently.

What you're describing is OBIEE's default behaviour of drilling down a dimensional hierarchy.

You can override this by changing the setting in the column properties;

Change this setting to Action Link and you can call a report which has the information you require at the specific level of the dimensional hierarchy.

In OBIEE 10g  it works as you expected , but in 11g it is not there the label displays full hierarchy while drilling down.

alternate way to make this is  create individual reports  and give action link one to another.

The functionality is there to show lineage which IS context for data ...  knowing lineage is crucial in more complicated logical hierarchy scenarios.

The concept of 'reports' needs to go away when dealing with an online analytical tool - breadcrumbs and lineage are part of the user experience in these tool-sets as the user can traverse up/down/across logical hierarchies.

So I agree the Truck/Large Truck looks dumb in a report ... looks fine in an interactive analysis in OBIEE -- by design.

*THANK* you. At least someone speaks out

Been repeating myself for over a decade!