Question:
We have 3 versions of hierarchies for 0PROFIT_CTR and all are loaded into BW. Users want to be able to select a version of profit center hierarchy when they execute the queries (that's easy). But, they also want to be able to select a node in the selected hierarchy when the selection screen pops-up. Unfortunately this variable is not in sync with the hierarchy selection variable. Irrespective of what the users select for the hierarchy variable, the hierarchy node variable shows the nodes for the Version 1 hierarchy only. This defeats the purpose of creating hierarchy node variable. Processing for this hierarchy node variable is "User Entry/Default Value". The other processing types for a hierarchy node variable are - SAP Exit (Not an option), Authorization (Not an option) and User Exit (May be not an option, since the user needs to be able to select the node the control should be given back to the user using the exit!!! Which I have not done before). If anyone has any ideas on this issue, please let me know. Thanks.
IS
PS - As profit center is also used as a free characteristic in the queries, the user will be able to select the correct hierarchy nodes once the query is executed, but the problem is at the selection screen level.
Answer:
We had this issue with cost center hierarchies, we ended up only including the variable for selecting which cost center hierarchy to use. The report runs for the entire hierarchy, then the user can filter on cost center and set a bookmark.
An alternative method would be creating multiple queries or views (one for each hierarchy) and using a dropdown menu web item in a template to allow users to switch hierarchies.