topic Re: VA: Data Source Mapping in SAS Visual Analytics

VA: Data Source Mapping

Phillip_B — Tue, 31 Oct 2017 11:44:54 GMT

Good Day

When using a Header Table (situated at the report level) to drive any number of detail tables within various sections I find it most confusing as to how VA (7.4) determines the mapping on the various fields. I also have the same key fields throughout all the tables with the expectation that it is meant to map on these fields. I have read the VAUG and still not any the wiser.

Urgently looking for more detailed information on how the mapping of data sources happens please.

best wishes

phillip

Re: VA: Data Source Mapping

ali_jooan — Fri, 03 Nov 2017 03:46:36 GMT

There are two ways you can map the two tables ..

1. through interaction .. once you will define interaction between two objects from different data sources, the mapping window will pop up and you need to provide mapping columns ..

2. If not interaction, you can use parameters to be set as filters ..

for example drop-down1 based on table1 is assigned column1, you can create a parameter and assign it as parameter for the same drop-down1. Once you choose a value from the drop-down1, the parameter will hold that value and say you have bar-chart1 based on table2's column1 .. you can filter the bar-chart1 where column1='parameter1'p ...

hope it helps ..

Re: VA: Data Source Mapping

Phillip_B — Fri, 03 Nov 2017 07:30:11 GMT

Thank you for the response Ali_Jooan

I am using both Interaction and Parameters in the manner you describe. Is
it that when using parameters the data sources should not be mapped with
the wizard??

thanks

Re: VA: Data Source Mapping

ali_jooan — Fri, 03 Nov 2017 08:50:37 GMT

Parameters are available regardless of the selected table thus they are available throughout the report and doesnt require interaction and thus no mapping is done ..

But if you use interaction between two objects one from table1 and the other from table2, a pop up window will ask you to map the two sources using the key or a combination .. if you are using any such interaction where two objects have two different data sources .. check the interaction and edit it .. at the pop up screen you will find the mappings right below the interaction options ..