Workbook - variable query 1 must be used for query 2

[Former Member]

Hi Experts,

i have been looking around but can not find information about my problem.

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?

[former_member194898 · Accepted solution]

Hi,

Have you thought about using an infoset to join data from both infoproviders ?

Then, it would be possible to create a variable on one of those characteristics.

Regards, Leszek

[Former Member · Accepted solution]

this is a possibility but they are complete different datasets, so this is not the way i want to go.

But it sure is a possibility.

[Former Member]

To be clear on this; this is not about joining data and it is not about precalculation.

So far i am afraid that the VBA macro is the only possibility.

Thanx for thinking with me; more advice will still be appreciated.

[kohesco]

Hi,

Could you try the RRI, please.Tcode: RSBBS

I have never used in within a workbook, I'm afraid the second query will just pop-up, but maybe that's okay for you ???

thanks

grtz

Koen

[former_member182470]

To pass values from one query to other in a workbook, you should write VBA Macro but not user exit.