BookmarkSubscribeRSS Feed
Coop
Fluorite | Level 6

Hello everyone.  Thank you for your help.  I am using SAS Visual Analytics 7.3.  I am using two control objects to filter a list table.  For example, LIST_1 filters LIST_2 which then filters LIST_TABLE_1.  I accomplished this through the Interactions View and it works as expected.  However, I would like to add an advanced filter to LIST1 and have that advanced filter passed down through the interactions.  I do not want to create a control object for users to control this filter.  Unfortunately, it appears that I am required to add the advanced filter to each control object and/or table.  I know that I can add a "Data Source Filter" but this type of filter is applied to every section of the report.  I would like to be able to create one advanced filter that would either filter everything in a section or a filter that could be applied to the "parent" and all "children" in the interactions.  Is this possible?  Thanks again for your help!

4 REPLIES 4
Madelyn_SAS
SAS Super FREQ

SAS Visual Analytics 7.3 supports both section-level filters and report-level filters. Althouguh, only certain controls can be used in these areas.

 

See "Use a Control to Create a Section Prompt" in the SAS Visual Analytics User's Guide:

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n148ej0xya6fr0n1wckjk...

 

or

"Use a Control to Create a Report Prompt" at
http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n148ej0xya6fr0n1wckjk...

Coop
Fluorite | Level 6

Thanks for your reply Madelyn.  It looks like the section and report prompts would require input from the report user, which is not what I would like to do.  I would like to either have an advanced filter that would filter all objects in the report section or be able to apply one filter to an object at the top of an interaction chain and have that filter "trickle down" to all child objects, without user input.  I'm just hoping to create reports that are easier to create and maintain.  If I have several control objects and need to have an advanced filter for each one, it increases the chance for error, is harder to create, and harder to maintain if a change needs to be made to the filter.  This would be a great feature to add to future releases.  Thanks again for your help.

SASKiwi
Opal | Level 21

I'm pretty sure what you say is correct. That an object filter (basic or advanced) only applies to the object it is defined in. You cannot reuse that filter in another object. I agree it would be great to have a section filter or global filter that you could define once and then reuse where you like.

 

You can have section prompts that work like filters but the flexibility of these is limited.

Coop
Fluorite | Level 6

Thank you for verifying this, SASKiwi.  I agree that this would be a helpful feature to add to future releases.

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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
  • 4 replies
  • 1493 views
  • 0 likes
  • 3 in conversation