Please ask the user how he expects this to work.

Scenario 1: Currently in ADS, a parameter belongs to a datasource (or query), not a worksheet. For example, if the user creates worksheet1 and worksheet2 on datasource1, which contains a parameter called param1, then param1 is automatically shared by worksheet1 and worksheet2. If the value of param1 is changed in worksheet1, then the new value is synchronized to worksheet2. We would not be able to change this behavior.

If the user is asking to change the "Link with Selected Datasources" dialog box such that the user can select from a list of worksheets rather than datasources, then that's possible. But the fact that a parameter belongs to a datasource remains true. For example in Scenario 1 above, if the user has the same param1 in worksheet3 which is created from datasource2, then linking param1 from worksheet3 to worksheet1 will also link to worksheet2.

This is what he's asking


I have a query that returns sales for a state

In a worksheet1 I show for Delaware

In worksheet2 I show for Maryland

I want a parameter called parm_state

I want the two worksheets to be independent so if I change the state on worksheet2 I don't want it to change on worksheet1

Currently, I'd have to create two different datasources with the identical query

Given the above scenario, the user should be using filters, not parameters.

In Worksheet1, drag and drop the State field onto the Filters deck. From the resulting filter control, select Delaware.

In Worksheet2, drag and drop the State field onto the Filters deck. From the resulting filter control, select Maryland.

Filters are independent in each worksheet, but can also be linked to multiple worksheets.

Please see VA-Filter-Example.vizx for example.

Nhi I do not have an app that will open a .vizx document or picture.  Can you attach one in a different format?

The .vizx is a VA workbook file. Just open it in ADS. Goto the top level menu Visual Analytics > Open. Please also share it with the customer.

Thanks Nhi.  I'e viewed it and forwarded it to the user.

Blair's comments:

But I want a parameter to be passed to the query!

I can't bring the entire dataset into a worksheet to apply a filter at the front end.

That defeats the purpose of having a dataserver

Please run this by the user to see I understand his use case correctly.

The user applied a parameter at the query, which yields datasource1. The user then created worksheet1 and worksheet2, both based on datasource1. He wants to apply a different parameter to worksheet1 and another parameter to worksheet2.

In this case the user can use a parameter to limit the query size. He can then use a filter as previously explained to further limit worksheet1 and worksheet2.

If my understanding is incorrect, please have the user explain his exact use case.

User's reply:

My use case is I have 100 million rows in a database. I can't bring in all 100 million rows into the client application, ADS or VA

I need to click on a row in VA and that would fill in a parameter which would send the query to the data server to retrieve 100 of the 100 million rows

Hi John,

I am going to reply directly to the customer via email.