BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jenny
Fluorite | Level 6

Hi,

 

I am trying to map two data sources in a report. One data source is feeding a drop down in the report prompt area while the other is feeding the visual. There is one common field bewteen the two data sets and when I map the two data sources on this field I had expected the drop down to then filter the visulaisation but it is not.

 

Can anyone suggest what I am doing wrong!

 

Many thanks,

 

Jenny

1 ACCEPTED SOLUTION

Accepted Solutions
MichelleHomes
Meteorite | Level 14

Hi Jenny,

 

While it is possible to use multiple data sources in a report (as you have found), only data items from the same data source will produce the interaction type filtering you are expecting. (See the text in the first Note at http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1bki2z2jxzsoen15hug3...

 

You might find that you can Map Data Sources to achieve what you want, depending on your data or you'll need to join the tables and loaded it into SAS VA as a joined table.

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

View solution in original post

1 REPLY 1
MichelleHomes
Meteorite | Level 14

Hi Jenny,

 

While it is possible to use multiple data sources in a report (as you have found), only data items from the same data source will produce the interaction type filtering you are expecting. (See the text in the first Note at http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1bki2z2jxzsoen15hug3...

 

You might find that you can Map Data Sources to achieve what you want, depending on your data or you'll need to join the tables and loaded it into SAS VA as a joined table.

 

Kind Regards,

Michelle

//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2064 views
  • 1 like
  • 2 in conversation