Changing hierarchies in BeX

[Former Member]

Hello

I've two SAP FI/CO hierarchies in use that show different structures of cost elements. Now, I'd like to give users the possibility to change the hierarchies directly in BeX (e.g. in a drop-down) instead of using to different queries. Is that possible? Has someone an idea? Thank you!

Regards

Patrick

[Former Member · Accepted solution]

Hi Patrick,

You can create a Hierarchy variable (not hierarchy node variable) to achieve this.

To do this, right click the characteristic and select properties.

select the hierarchy name selection button.

check the variables check box

create a variable

Now the user can chose which hierarchy to be diplayed before running the query and change it if they want after running the query

Good luck,

Vijay

[Former Member · Accepted solution]

Hello Vijay

Thank's for your answer. I've just done that. Unfortunately, the variable doesn't appear in the dimensions on the left side of the Query Designer. So I can't use it as a default value...

And: I already have some hierachie variables. The one I probably need is 0H_PLACC. But as mentioned above: I can neither add it to the default values nor can I use the variable e.g. in a drop-down in BeX.

I'm sure that it's possible but I don't know how to add that functionality to my report..

[Former Member · Accepted solution]

Patric - there is a little trick to this

When in query designer - select a hierarchy then change the right hand side pull down to variables - then on the left you will see the variables

[Former Member · Accepted solution]

All right. Now, it works. Thank you for your help!