cancel
Showing results for 
Search instead for 
Did you mean: 

BExAnalyzer: Multiple use of the same Query in a Workbook - Command Button

klaus_buchner2
Explorer
0 Kudos

Hy Gurus,

in my Workbook I have in Sheet 1 one Analysis Grid, defined as DP_1

in Sheet 2 it is an other Analysis Grid defined as DP_2

Both Data-Provider refer to the same technical BW Query.

If I add a Button (from the BEx Toolbar) and try to refresh the first query (with commands: PROCESS_VARIABLES and VAR_SUBMIT) both Queries will be refreshed with the same variable value, even if i mention "DP_1" as Data_Provider in the button.

But I don't want, that the second query is been refreshed too (with the same variable value).

In the workbook Settings, I already checked on: Allow refresh Function for Individual Queries.

Can anybody help?

Regards

Klaus

View Entire Topic
klaus_buchner2
Explorer
0 Kudos

It is not a solution to copy the query. We will need this feature for about 50 Workbooks/Queries and so it is the problem to keep the copied queries consistent

If I refresh the Queries manual with the the "Change Variable Values" Button I get a pop-up with two fields where i can input two different values - here it works.

Can I achieve the same with the command buttons?

The definition of the first command button is like this:

Name Index Value

DATA_PROVIDER 1 DP_1

CMD 1 PROCESS_VARIABLES

SUBCMD 1 VAR_SUBMIT

Command Range: A2:C5 (there is the Name, Value, Sign and Operator of the Variable).

The second command Button:

Name Index Value

DATA_PROVIDER 1 DP_2

CMD 1 PROCESS_VARIABLES

SUBCMD 1 VAR_SUBMIT

Command Range: A12:C15 (with a different Value of the Variable).

If there is one query in the workbook it works fine, but not for two queries, even if I change the Index of the second button to 2.

Thank you for your hints.

Regards

Klaus

Former Member
0 Kudos

What you need to do in this case is to untick the box in the workbook settings variable tab which says "Show duplicate variables only once".

This should solve your problem

Gareth

klaus_buchner2
Explorer
0 Kudos

Hy Garet,

I already untick this box, but I still face the same behaviour.

Regards.

Klaus