BookmarkSubscribeRSS Feed
Obsidian | Level 7

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!!! 🙂

Rhodochrosite | Level 12
Which version of VA are you using?
You should be able to do this eiter with report linking or using parameters.
Obsidian | Level 7
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
Rhodochrosite | Level 12
Hm, you might need to prepare the tables, add the attributes to each if them..



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 3 replies
  • 2 in conversation