Cisco Acs 5x User Guide

							13-67
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Figure 13-43 Suppressed Values
You can suppress duplicate values to make your report easier to read. You can suppress only consecutive 
occurrences of duplicate values. In the Location column in Figure 13-43, the Boston value is suppressed 
in the second, third, fourth, and fifth rows. If Boston occurs again after the listing for NYC, that 
occurrence of Boston is visible and subsequent consecutive occurrences are suppressed. The values must 
be exact duplicates to be suppressed.
If a column splits across multiple pages, the first row on each page displays a value, even if duplicate 
values are suppressed for that column.
You can suppress this feature by doing the following:
Step 1Select and right-click the column that contains duplicate values. 
Step 2From the context menu, select Column > Do Not Repeat Values.
Displaying Repeated Values
To display repeated values:
Step 1Select and right-click the column that does not repeat duplicate values. 
Step 2From the context menu, select Column > Repeat Values.
Hiding or Displaying Detail Rows in Groups or Sections
If a report contains groups, you can collapse and expand a group by using the context menu. 
For example, Figure 13-44 shows a report where the data is grouped by creditrank and the detail rows 
for each creditrank value are shown.  
						

							13-68
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Figure 13-44 Group Detail Rows Displayed
Figure 13-45 shows the results of hiding the detail rows for the creditrank grouping.
Figure 13-45 Group Detail Rows Hidden

To collapse a group or section, select and right-click a member of the group or section that you want 
to collapse.
The context menu appears. 
To display the group members without their detail rows, select Group > Hide Detail. 
To display the group members with their detail rows, select Group > Show Detail. 
Working with Filters
Filters limit the data that appears in reports. For example, by using a database of customer data, you can 
use filters to run a report that lists only the customers in a specific state or province, or only the 
customers whose purchases total more than $1.5 million. 
To limit the data even more, you can, for example, list customers in a specific state who have credit limits 
of less than $50,000 and who have not made a purchase in the past 90 days.
A filter is based on one or more fields in a report. 
To create a filter based on a single field, you select a condition and a value. For example, you can create 
a filter that returns values that are equal to a specified value, less than a specified value, between two 
values, and so on. Table 13-14 describes the conditions you can select.
Table 13-14 Conditions to Use with Filters
Condition Description
Any Of Returns any of the values you specify.
Between Returns values that are between two specified values. When you select 
Between, a second Value field appears for the second default value.  
						

							13-69
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Types of Filter Conditions
Table 13-15 describes the types of filter conditions and provides examples of how filter conditions are 
translated into instructions to the data source.Bottom N Returns the lowest n values in the column.
Bottom Percent Returns the lowest n percent of values in the column.
Equal to Returns values that are equal to a specified value.
Greater Than Returns values that are greater than a specified value.
Greater Than or Equal to Returns values that are greater than or equal to a specified value.
Is False In a column that evaluates to True or False, returns data rows that contain 
false values. 
Is Not Null Returns data rows that contain values. 
Is Null Returns data rows that do not contain values. 
Is True In a column that evaluates to True or False, returns data rows that contain 
true values. 
Less Than Returns values that are less than another value.
Less Than or Equal toReturns values that are less than or equal to another value.
Like Returns strings that match all or part of the specified string. % matches zero 
or more characters. _ matches one character.
Not Between Returns values that are not between two specified values. When you select 
Not Between, a second Value field appears for the second default value.
Not Equal to Returns values that are not equal to another value.
Not Like Returns strings that do not match all or part of the specified string. % 
matches zero or more characters. _ matches one character.
Top N Returns the top n values in the column.
Top Percent Returns the top n percent of values in the column.
Table 13-14 Conditions to Use with Filters (continued)
Condition Description 
						

							13-70
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Setting Filter Values
After you choose a condition, you set a filter value.
Step 1To view all the values for the selected column, select Select Values. 
Additional fields appear in the Filter dialog box as shown in Figure 13-46. These fields allow you to find 
and select a filter value.
Table 13-15 Examples of Filter Conditions
Type of filter 
condition Description Examples of instructions to data source
Comparison Compares the value of one expression to the value 
of another expression using:
Equal to
Not Equal to
Less Than
Less Than or Equal to
Greater Than
Greater Than or Equal to
quantity = 10
custName = Acme Inc.
custName > P
custState  CA
orderDate > {d 2005-06-30}
Range Tests whether the value of an expression falls or 
does not fall within a range of values using 
Between or Not Between. The test includes the 
endpoints of the range.price BETWEEN 1000 AND 2000
custName BETWEEN E AND K
orderDate BETWEEN 
{d 2005-01-01} AND {d 2005-06-30}
Membership Tests whether the value of an expression matches 
one value in a set of values using Any Of.officeCode IN (101,103,104)
itemType IN (sofa, loveseat, endtable, 
clubchair)
orderDate IN 
({d 2005-10-10}, {d 2005-10-17})
Pattern-matching Tests whether the value of a string field matches or 
does not match a specified pattern using Like or 
Not Like. % matches zero or more characters. 
_ matches one character.custName LIKE Smith%
custName LIKE Smiths_n
custState NOT LIKE CA%
Null  value Tests whether a field has or does not have a null, or 
missing, value using Is Null or Is Not Null.manager IS NULL
shipDate IS NULL
shipDate IS NOT NULL 
						

							13-71
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Figure 13-46 Selecting a Filter Value in Interactive Viewer
Step 2
To search for a value, type the value in the Find Value field, then click Find. 
All values that match your filter text are returned. For example, if you type:
40
the text box displays any values in the column that begin with 40, such as:
40
400
4014
40021
When you see the value you want in the large text box, double-click the value. The value appears in the 
Value field.
Creating Filters
To create a filter:
Step 1In Interactive Viewer, select a detail column and choose Filter.
If the detail column you selected is a merged column, the Select data item dialog box appears. 
Step 2From the Select date drop-down list, select the column name for which you want to apply a filter, then 
click Apply. 
The Filter dialog box appears. The name of the column you selected appears in the Filter By field. You 
cannot change the name. 
						

							13-72
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Step 3From the Condition pulldown menu, select a condition. Table 13-14 describes the conditions you can 
select. 
If you select Between or Not Between, Va l u e  F r o m and Va l u e  To, additional fields appear to 
display a range of values. 
If you select Is False, Is True, Is Null, or Is Not Null, no value fields appear. For all other 
selections, a single value field appears. 
Step 4Enter values in each of the available fields. 
To view all possible values for the column, click Select Values and select from the drop-down list.
Step 5Click Apply. 
The results of applying the filter are displayed.
Modifying or Clearing a Filter
To modify or clear a filter:
Step 1Select the column that uses the filter. 
Step 2Select Filter. 
The Filter dialog box opens, displaying the existing filter condition
To modify the filter, change the setting in the Condition field or change the values. 
To remove the filter, click Clear. 
Step 3Click Apply.
Creating a Filter with Multiple Conditions
You can create a filter with more than one condition. For example, you can create a filter that retrieves 
the names of customers who have a credit rank of either A or B, and who have open orders totaling 
between $250,000 and $500,000. 
To create a filter with multiple conditions, you choose Advanced Filter on the Filter dialog to use the 
Advanced Filter dialog box. The Advanced Filter dialog box for Interactive Viewer is shown in 
Figure 13-47. 
						

							13-73
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Figure 13-47 The Advanced Filter Dialog Box in Interactive Viewer
Advanced Filter provides a great deal of flexibility in setting the filter value. For conditions that test 
equality and for the Between condition, you can either set a literal value or you can base the value on 
another data column. 
For example, you can request actual shipping dates that are greater than the forecast shipping dates, or 
actual sales that are less than sales targets. To do this:
Step 1Select a column, then select Filter. 
The Filter dialog box appears.
Step 2Click Advanced Filter.
The Advanced Filter dialog box appears. The Filter By field displays the name of the first column in the 
report.
Step 3From the Filter By menu, select the column that contains the data you want to filter.
Step 4In the Condition field, select a condition, such as Equal To, Between, or Less Than.
Step 5In Value, select one of the following options:
Specify literal value—This is the default selection. To specify a literal value, type a value in the 
field provided. If you click Select Values, a field appears displaying all data values for the specified 
column. For long lists, you can find a value by typing the value in the Filter Text field and clicking 
Find.
Use value from data field—When you select Use value from data field, a drop-down list of columns 
appears. The columns in this list have the same data type as the column you selected in the Filter By 
field. 
Step 6Click Add Condition. 
The filter condition appears in Filters. 
						

							13-74
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Hiding and Filtering Report Data
Step 7Validate the filter syntax by clicking Va l i d a t e.
You have now created a filter with one condition. The next step is to add conditions.
Step 8Follow steps Step 3 to Step 7 to create each additional desired filter condition. 
Step 9In Filters, adjust the filter conditions to achieve the desired filtering. You can combine the conditions in 
the following ways:
Using AND, OR, and NOT
By default, the second filter condition is preceded by AND. AND means that both conditions must 
be true for a data row to appear in the report. You can change AND to OR by choosing OR. OR 
means that only one condition has to be true for a data row to appear in the report. 
If you choose NOT, NOT appears after the AND or OR. NOT means that the condition must be false 
for a data row to appear in the report.
If you add more than one condition, you can use the parentheses buttons to group conditions.
If you enclose two or more filter conditions in parentheses, the conditions in the parentheses are 
evaluated first. Then, the entire filter expression is evaluated. 
For example, A AND B OR C is evaluated from left to right, so A and B must be true or C must be 
true for a data row to appear in the report. In A AND (B OR C), B OR C is evaluated first, so A must 
be true and B or C must be true for a data row to appear in the report.
Deleting One Filter Condition in a Filter that Contains Multiple Conditions
To delete a filter condition:
Step 1Select a detail column, then select Filter. 
The Filter dialog box appears.
Step 2Click Advanced Filter. 
The Advanced Filter dialog box appears. The lower portion of Advanced Filter displays all the filter 
conditions in the report.
Step 3Select a filter condition to delete, then click Delete.
Step 4Click Apply.
Filtering Highest or Lowest Values in Columns
When a table contains hundreds of rows, it can be helpful to display the highest or lowest values in a 
column. For example, you might want to view the ten sales representatives who produce the most 
revenue or the top twenty-five percent of energy consumers.
To perform this type of filter:
Step 1Right-click a selected column, then select Filter > Top or Bottom N
The Top or Bottom N dialog box appears. 
						

							13-75
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Understanding Charts
Step 2From the Filter pulldown menu, select a particular number of rows or a percentage of rows, as shown in 
Figure 13-48. 
Step 3Enter a value in the field next to the Filter pulldown menu to specify the number or percentage of rows 
to display. 
For example, to select the top 10 sales representatives by sales volume, after you have selected the 
column that contains sales volume data and chosen Filter > Top or Bottom N, in the Top or Bottom N 
dialog box, select To p  N and enter 10.
Figure 13-48 Sorting Top or Bottom Values in a Column
Step 4
Click Apply.
Understanding Charts
A chart is a graphical representation of data or the relationships among data sets. Charts display complex 
data in an easy-to-assimilate format. Figure 13-49 shows the parts of a basic bar chart. A chart displays 
data as one or more sets of points. The chart organizes data points into sets of values called series. The 
two types of series are:
Category series— The category series typically determines what text, numbers, or dates you see on 
the x-axis. 
Value series—The value series typically determines the text, numbers, or dates on the y-axis. 
In Figure 13-49, the category series contains a set of regions, and the value series contains a set of sales 
figure values. 
						

							13-76
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13      Managing Reports
  Understanding Charts
Figure 13-49 Parts of a Basic Bar Chart
There are a variety of chart types. Some types of data are best depicted with a specific type of chart. 
Charts can be used as reports in themselves and they can be used together with tabular data report styles.
Modifying Charts
The basic characteristics of a chart are determined in the report design editor. Such things as the chart 
type and the data source are part of the report design and cannot be changed in the viewer. You can 
change the following aspects of the chart:
The Interactive Viewer presents the capability to:
Filter the data presented in the chart
Change the chart subtype
Change the chart format
Select these options from a context menu by right-clicking on the chart in Interactive Viewer.
Filtering Chart Data
The data displayed in the chart can be filtered in much the same way that any data column is filtered. 
With a chart you can filter either the x-axis or the y-axis. To do this:
Step 1Right-click on the chart to display the context menu. 
Step 2Select Filter. 
The Chart Filter dialog box appears.