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

Note that this task is optional. Optional tasks do not need to be performed as part of the tutorial. They are provided

for information only.

To change the data sort order for multiple columns at one time, perform these tasks:

a. Hold down the Ctrl key and select the desired columns from the Column list.

b. Click Order By.

Integration Services displays the Order By dialog box.

Figure 197 Order By Dialog Box

c. Select Ascending or Descending and click OK to return to the Select Data Sort Order dialog box.

4 Click Next to display the Select Data Filters dialog box, and follow the steps in the topic, “Filtering Data”

on page 182 to customize the report further.

Filtering Data

You can create and apply filters to determine what Integration Services retrieves for the drill-

through report. You can also save, edit, and delete the filters that you create. For any given

column, you may want to retrieve only data that meets certain conditions. For example, the

MEASURES.CHILD column in the sample database contains all children of the Measures

dimension.

In the sample drill-through report, if you do not apply a filter to this list of measures, Integration

Services retrieves all children from the relational source, because the sample drill-through report

applies to all children of Measures. In this section, you will apply a filter to the

MEASURES.CHILD column so that all children of Measures, except Misc, are included in the

report.

Note:

When you apply a filter on a non-level 0 member using Integration Services, the filter may return

more members than expected. To work around this problem, use the Drill-Through Wizard.

➤ To define a filter:

1 Select the MEASURES.CHILD column from the Column list.

182

Using Drill-Through

1 2 ... 177 178 179 180 181 182 183 184 185 186 187 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 182