COPY SHEET in 7x Analyzer issue

[Former Member]

Hi All,

Please advise how you can take care of this problem :-

When you do Copy sheet or insert Analysis grid from Design mode, if you choose 2nd Query which doesnt have any COMMON VARIABLE between 2 queries in your workbook, the moment you try to come out of design mode , the 2nd query is being processed wide open because it doesnt have any selection input given to it.....

Example, on Tab1 i have invoice Query, on Tab 2 I Insert Analyssis grid and choose QRY2, lets say Sales orders booking Qry and they have no common variables....now the 2nd qry is gettting processed for the whole selection by default.....how do you take care of this.....maybe I want to force "change variable triggering" so that i am prompted for selection screeen like 3x....can you do that ?

thanks,

Bobby.

[Former Member · Accepted solution]

Hi Bobby,

Open the workbook settings --> Variables tab --- > select the check box for process variables on refresh . So that when you open your workbook it will pop up variable screen.

Hope this helps. Let me know if you have any questions.

Regards

Suvarna

[Former Member]

Thanks Suvarna,

It doesnt work....if you try what i requested, the selection screen doesnt popup unless and untill you click on change variable button...

pls try simple steps, it wont take more than 5 mins, you will see the issue I am talking about.....it starts processing 2nd Query the moment you try to come out of design mode but doesnt prompt for variables and runs wide open....

thanks

bobby