how to do dynamic selection of hierarchies during query execution based on cost center ?
Cost center- User selection
Based on this should dynamically select hierarchy for cost element.(there are multiple hierarchies maintained for cost element)
Also cost center to hierarchy is one to one, the relationship is maintained in DSo- 'ZXXXXX'
Eg: CostCenter1 Hierarchy1
So during query run time, when user key in 'costcenter1' the query should pick up 'hierarchy1' and diplay.
Is it possible? how to achieve this?
Thanks in advance.