Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Problems mapping datasets in Report Designer

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

Problems mapping datasets in Report Designer

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


Accepted Solutions
Solution
‎05-26-2016 05:41 AM
Super User
Posts: 1,206

Re: Problems mapping datasets in Report Designer

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

View solution in original post


All Replies
Solution
‎05-26-2016 05:41 AM
Super User
Posts: 1,206

Re: Problems mapping datasets in Report Designer

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

Post a Question
Discussion Stats
  • 1 reply
  • 178 views
  • 1 like
  • 2 in conversation