Skip to Content
Author's profile photo Former Member

Including Query with Different selections in a Workbook

Business Requirement:

Business want to include two queries in a workbook. The query is same but the variable selection is different from each other. These should be displayed in two different tabs of a workbook.


Now when I change the Sales Org in First Tab to “X” then it also changes to the Second Tab. And that is something Business doesn’t want.

Settings to be maintained

  1. Go to Workbook Settings à Variable tab. Uncheck “Display Duplicate Variables Only Once”
  2. Go to Workbook Settings à General tab. Check “Refresh Workbook on Open”
  3. Save the Workbook.
  4. Open the Workbook. You will get 2 variable screens in 1 dialog box, 1 for each of the 2 sheets maintained in the workbook.






Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      good one srinivas