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

Figure 193 Select Columns and Display Order Dialog Box

7 Follow the steps in the topic, “Selecting and Ordering Columns” on page 179, to select and order rows for

the customized report.

Selecting and Ordering Columns

Using the Drill-Through Wizard, you can customize predefined drill-through reports. The first

task in using the Drill-Through Wizard is selecting and ordering columns to retrieve from the

relational database. These columns contain detailed information that is not available in the

Essbase database.

In the Select Columns and Display Order dialog box, you can select which columns you want

Integration Services to retrieve from the relational data source. From this dialog box, you can

also specify how the columns are displayed in the resulting report.

The Available Columns list consists of columns available from the relational data source for this

report (as defined in Integration Services Console). The Selected Columns list box consists of

the columns from the Available Columns list in expanded form. You can remove columns from

the Selected Columns list to exclude them from the drill-through report.

In this example, the columns from the Available Columns list are selected for inclusion in the

sample Measures detail report. These columns are displayed in expanded form in the Selected

Columns list.

➤ To remove one of the selected columns from the drill-through report:

1 From the Selected Columns list, select the MARKET.STATE column., as shown in Figure 194.

Note:

To select multiple columns in the list that are not adjacent to each other, hold down the Ctrl key

and select each column. To select a range of columns, hold down the Shift key and click the first

and last columns in the list, which also selects all columns in between them.

Using Drill-Through

179

1 2 ... 174 175 176 177 178 179 180 181 182 183 184 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 179