For this requirement:
"user could search for a name and return results at any level",
my suggestion is creating a filter with calculation field and parameter.
(1). Create a parameter: USER_SEARCH_STRING
which could be a free key-in parameter, or a list combined with any name of L1~L18.
(2). Create a calculation field : SHOW_SEARCH_OUTCOME, , which type is Boolean
( [LV1] == [USER_SEARCH_STRING] )
( [LV2] == [USER_SEARCH_STRING] )
( [LV18] == [USER_SEARCH_STRING] )
(3). Move this calculation field SHOW_SEARCH_OUTCOME into filter, and show only it is TRUE.
And it need only one parameter to filter multiple level columns.
Thanks this is useful and can definitely find ways to utilize.
There are few problems with this solution:
- Hierarchy names are not unique ( the ID's are but users will not know those). The name on Level 7 of a certain branch could match the name of Level 14 on another.
- Users will sometimes need to filter on multiple items at certain level of the hierarchy.
- Not all users will know the exact name they are searching for. They might just know it exists under a certain branch.
Thanks for the help.