Remove full drill path from chart label

MrsJ

We have a dashboard that shows a pivot table and a chart that has a drill for a location. The top level of the hierarchy is the region (i.e. Asia/Europe etc) and we can then drill down through various levels down to a city and then a building. The customer is not keen on how in the charts when you drill it shows the full path, concatenating each of the levels together and would prefer to only see the lowest level of the hierarchy that you have expanded to. So for example instead of seeing "Europe United Kingdom Aberdeen" they just want to see "Aberdeen".

We need the pivot table to link to the chart automatically so cannot use a hierarchy in the pivot/chart instead as that means the user has to drill in 2 places as the drill on the pivot doesn't "talk" to the chart.

I am aware this is the standard functionality of OBIEE but I'm interested to see if there is a workaround for this that anyone has used.

We are on version 11.1.1.9.0

[Deleted User]

Replied elsewhere to this but same answer here:

This is how Answers works. No you can't change it because then you'd have to rewrite the whole charting engine.

Visual Analyzer does it differently though so when you go to 12 you'll have an alternative.

MrsJ

I did try to search for a similar post but couldn't find anything I thought that would be the case but wasn't sure if someone had come up with some magic way of doing it.

Thanks.

[Deleted User]

No, no magic to be done here. Answers treats that as a drill in the "link drilling" kind of way so it leaves breadcrumbs.