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
127

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

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..