In this section:
Once you add slicers to an InfoAssist report, you can use them to filter the report. You can select values from the slicers menus, change the number of records that appear, create new slicer groups, clear existing slicer groups, and update the report preview.
Slicers that are not selected have their values filtered by the selected slicers. Only values that meet the criteria for previously selected slicers will appear in the menu for the next slicer. Slicers are not filtered in the order they appear in the slicer group, but by the order they are selected. Cascading of slicers is only valid for hierarchies.
For alpha fields, the available operators are:
For numeric and date fields, the available operators are:
A list of operators (numeric) appears in the menu, as shown in the following image.
Note: Alpha fields just flip between equal and not equal.
Slicers cascade within a hierarchy (cube or dimension builder-based), rather than in the order of user interaction, eliminating potential performance issues.
Controls with fields from the same hierarchy are cascaded together. In the following example, a report has been created that shows the quantity of products, by category, sold each year.
In the following example, two groups have been created for this report: Product and Time (Sales). Both are from hierarchies, so they will cascade.
In the next example, Televisions is selected as the first control for the Product group.
Once you click OK, the new control appears in the drop-down menu, as shown in the following image.
The 1 prior to the decimal point indicates that this is the first cascade you have interacted with. The 1 after the decimal point indicates that it is the first control in that cascade.
In the next example, Flat Panel TV is selected as the second control for the Product group, as shown in the following image. This is filtered to only show subcategories for Televisions.
Flat Panel TV appears in the Product Subcategory drop-down menu, as shown in the following image.
The number 1.2 indicates that this is the second control for the first cascade.
Now, a second group, Time (Sales) is created. It has two controls: the first is Year (Sales) and the second is Quarter (Sales), as shown in the following image.
In the following example, the report has been filtered to show the number of flat panel televisions that were sold in the first quarter of 2007.
Note: The order of a cascade is dynamic. For example, if you selected Camcorder from Product Subcategory first, then the Product Category control would have a value of Video Production.