How to create a prompt that can change between different hierarchies ?

[former_member598792]

Hey There,

I've a question regarding BEx prompts with hierarchy.

We have created several different hierarchies (1. level) for 0FUND and I would like to create a prompt that can filter for the specific hierarchy that the user prompts.

With some hard sweat I've found out that I need to do both a hierarchy node variable and a hierarchy variable cause only the hierarchy node variable able to filter in the selection but only those values that are prompted in the hierarchy variable can be chosen as node variable in the prompt in alayzer, so if I want to use it in the analyzer i need to put out both to choose freely hierarchy.

My question is can i merge the two (hierarchy variable and hierarchy node variable) somehow so I only need to use one prompt on the query ?

Thanks Andras