topic Re: One report to filter another dataset in SAS Visual Analytics

One report to filter another dataset

LukeL — Tue, 14 Jul 2020 13:17:41 GMT

Hi all,

I have somehow a dumb question, but understand if what we need to obtain is somehow feasible or not.

We have some tables Y1..Yn that all have in common a certain ID (possibly not unique) and a table X that hase the ID associated informations.

What we need/would like to obtain is this:

in one report, prepare a lot of objects that act as filters to identify some IDs (the filters come from all the tables Yn, and do not filter by ID, they just identify some IDs).

in another report (or page) having a table objects that show the ID from the X table filtered for just the IDs (possibly hundres of) identified by the "filter report".

Is this obtainable in some way? Actually we have mange to filter the second table just by mapping the two tables by all the columns we use to filter, but se last table does not have them all, since they would cause duplications on data...

Thanks for any support!!! 🙂

Re: One report to filter another dataset

FredrikE — Mon, 10 Aug 2020 09:43:38 GMT

Which version of VA are you using?
You should be able to do this eiter with report linking or using parameters.

Re: One report to filter another dataset

LukeL — Mon, 10 Aug 2020 10:14:07 GMT

Hi, we've tried with both 7.5 and 8.4, but with no luck... In all the version it expect that data source linking is build on columns available in the report object from witch you make the link on the other... At least as far as we have been able to see

Re: One report to filter another dataset

FredrikE — Mon, 10 Aug 2020 15:46:41 GMT

Hm, you might need to prepare the tables, add the attributes to each if them..