Workbook - variable query 1 must be used for query 2
i have been looking around but can not find information about my problem.
I have a workbook with 2 queries on two different multiproviders.
Both queries have a variabele on a hierarchy. One is about 0COSTCENTER, one is about 0PROFIT_CTR.
Because these two hierarchies are equal i would like to use the selected costcenter node in the 0profit_ctr variable as well
(so that user doesnot have to enter this selection value).
So i tried in the user exit to get the selected value from the other query.
My i_t_var_range table however seems to contain only the values for the query that is currently processed .
Is there a way in the user exit to find the variable values for all the queries in a workbook?