A bit of background before my questions.
I have created a UX view where the user can select an element from a dimension e.g. profit centre. The users are having difficulty selecting the element they need. They don’t know the profit centre code to filter on and the description isn’t always obvious. In Perspectives they drill down the division, group, sub-group, branch and then select the applicable profit centre. Once they see the profit centres in that branch it’s clear to them which one they what. With the UX selection, they either have to filter on the cost centre code, which they don’t know or the name, which they don’t necessarily know - it could be similar to the branch name (which may be a location) or it could be a more specific area in that location. There’s about 2000 elements in the dimension so it’s a large number to drill down and too many to remember.
The filter functionality isn’t much help as we don’t have anything to filter on. Collapsing the consolidation doesn’t help as when it is expanded it is fully expanded again (unlike perspectives).
So, my question is… Is there a way to stop the the selection expanding all the way to the bottom, after it’s been collapsed) and behave more like perspectives? Or is there something I’m missing?