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.

Issue:

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.

Settings1.png

Settings2.png

Output:

Settings3.png

Settings4.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply