Problems mapping datasets in Report Designer

jenny — Wed, 25 May 2016 11:45:06 GMT

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

Re: Problems mapping datasets in Report Designer

MichelleHomes — Wed, 25 May 2016 12:00:33 GMT

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#p1bki2z2jxzsoen15hug3tc653a6.htm)

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

topic Problems mapping datasets in Report Designer in SAS Visual Analytics

Problems mapping datasets in Report Designer

Re: Problems mapping datasets in Report Designer