For one of the requirement at client site I have added Query Prompt Selector component in Dashboard canvas from the source BEx query hierarchy node variable using Query browser-->Add Query-->BEx Query with Hierarchy node variable. Functionality works as expected but only problem I am facing is performance because expansion or hierarchy node/level selection is very slow. It takes 40 to 45 seconds to expand hierarchy levels. If anyone faced this problem or if its know issue than is there are any SAP note to fix it? Your inputs are very helpful and rewarded for the valuable inputs.
It's straight forward BEx hierarchy node variable without any exits and it doesn't have many levels as well. Volume of data in Info providers is less than 150,000 records, BEx query at each node selection brings maximum of 1000 rows.
Settings in Hierarchy prompt in Dashboard: General--> Refresh when Selection changes. Behavior--> Enable Search in LOV, display caption. Appearance-->Expanded, Expand level to 3.
BW 7.30 SP2
BI 4.0 SP4