Lesson: 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 a selected column from the drill-through report:

  1. From Selected Columns, select the MARKET.STATE column.

    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.

  2. Click Left-facing arrow icon to move the selected column from the Selected Columns list back to the Available Columns list.

  3. Click Next to display Select Data Sort Order, and follow the steps in the topic, Lesson: Ordering Data to further customize the report.

    Note:

    When you finish customizing the report, click Finish to generate the report and view the results in a worksheet. The new sheet is placed before the current sheet.