Creating a Publication having Hierarchies using Webi
I have a challenge....
We have hierachy on Organisation Unit. A BEX query where the Hierarchy is enabled and we created a hierarchy variable for selection so we can select any node in the hierarchy so that the aggregation is done to the node for a report. We created an universe on the BEX query, and the report... the hierachy variable raises a prompt when the report is run and works as expected.
Now, we need to create a Publication using Dynamic Recipients. This is where the challenge is... how??? Webi filters on fields... The dynamic recipient list will have the node in the hierarchy as a field, however, the source document uses a prompt for the hieratchy node to be selected, but I need to have this as field to filter on... any idess on how to solve this...???