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!
I wasn't trying to say that having the lineage displayed was never a good feature, but rather was trying to come up with a solution that works in OBIEE and makes the bosses happy. Hopefully it will be a switch you can turn on/off in the future.
Thanks for the input