Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 185)

Figure 201 Defining a Filter for a Column

The filter defined above causes all children of Measures, except Misc data, to show in the drill-

through report.

The Add button becomes unselectable after you create the first filter, but becomes selectable

when you create another filter. In this tutorial, you are creating only one filter. The And and Or

options are used when combining multiple filters. The default value is Or, which means that

Integration Services applies the filter if any of the conditions that you specify are met. If you

select And, Integration Services applies the filter only if all the conditions are met.

8 Click OK to return to the Select Data Filters dialog box.

Notice that the filter defined in the Set Filter on Column dialog box is displayed in the Condition

column and the Condition text box of the Select Data Filters dialog box.

Figure 202 Result of Defining a Filter for a Column

You can also create a filter by typing the filter conditions directly into the Filters text box of the

Set Filter on Column dialog box. For more information, see the Drill-Through online help.

Using Drill-Through

185

1 2 ... 180 181 182 183 184 185 186 187 188 189 190 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 185