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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi all,

we are facing the same issue.

Who was able to find a solution?

thanks a lot!

Martin

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

klaus_buchner2
Explorer
0 Kudos

Dear srinivas,

I had already unchecked this property, but it didn't work.

Any other ideas?

Regards

Klaus

Former Member
0 Kudos

when you uncheck that box ..are you able to see variables screen by DP..in the same screen you will see all variables for DP1, then DP2..

if you are not able to see two different panels for variables, I would suggest you to copy your query and rename it and use in workbook..

thats what I would do..

Former Member
0 Kudos

In workbook settings - variables tab-- uncheck ' display duplicate variable only once' ..

then you will get all the variables from DP1 followed by DP2..

it should work..