Filters on Numeric Values in Info Map Studio and Web Report Studio

0

When creating a filter on a numeric value in Information Map Studio, the query doesn't include the filter when used in Web Report Studio. The classification of the variable must be changed from "Measure" to "Category". (Measure is automatically used for incoming numeric values.)

For instance, SASHELP.SHOES has a 'Number of Stores' variable that is represented numerically. We would like to create an information map that only shows large subsidiaries (with more than 20 stores). If you add a filter on 'Number of Stores' > 20, this will not work properly.

Therefore right click on the 'Number of Stores' variable and change the classification to "Category". Everything will then work peachy.

Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Comments are closed.

Back to Top