BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools

Information Maps: My cascading filter does not work …

Submitted by on 2011-12-02 – 6:00 AM

After you have setup the cascading filter from SAS Information Map Studio, you run a test and notice that the cascading filter is not working properly. Instead of filtering on your desired variable – it returns everything. Eeek … how could this happen to a programming deity such as yourself? Let’s find out …

Testing the Information Map Filter

In this example, I was setting up a cascading filter so that once an employee is selected all the customers for that employee appear. However, if you select the company president, Diane Murphy; all of the customers are available.  Diane is not a sales rep and should not have any customers available to select.  However, in the following screen capture – you see that I can select every customer available.  My cascading filter was not working properly. 


Information Map Needs a More Dynamic Filter

In this example, the parent filter is Employee and the child filter is Customer. To determine what is wrong, you can open the child filter called CustomerCasFilter to explore. I found the issue in the CustomerPrompt. When I setup the prompt, I had made the list population method list static instead of dynamic. As a result, the prompt was using the static list (meaning values I had supplied) instead of dynamically filtering (all values available) using the Employee name.

Information Map Studio Cascading Filters

Information Map Studio Cascading Filters Issue

 

Test the Information Map Again

Once I set the prompt to be dynamic, the filter worked properly.  To demonstrate to myself that it worked, I ran two tests.  In the first one I selected Diane Murphy; there were no customers available to select and no values returned. Leslie Thompson was selected for the second test. The list correctly contained only the customers Leslie represented.

Information Map Studio Cascading Filters

Information Map Studio Cascading Filters Test – Repaired!

 

Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.

Tags: ,