Selecting and Ordering Columns

In the Select Columns and Display Order dialog box, you select source columns from to be displayed in the drill-through report, and you determine the display order of columns across the spreadsheet. These columns contain detailed information not available in the Essbase database; for example, a list of store managers.

The Selected Columns list box displays the columns from the Available Columns list box in expanded form. These columns are part of the drill-through report (as defined in Integration Services Console by an administrator at your organization). You can move columns out of the Selected Columns list box to exclude them from the drill-through report.

  To select and order columns for the drill-through report:

  1. In Available Columns, select the column to include in the report.

    Click Expand tree icon. to view all columns in a dimension.

  2. Use the arrows to move selected columns to and from Selected Columns.

  3. To rearrange the display order of columns, select a column to rearrange in Selected Columns, and then click Move Up or Move Down.

  4. When all columns that you want included in the report are displayed in the correct order in Selected Columns, perform an action:

    • Click Next and follow the steps in Selecting Data Sort Order to further customize the report.

    • Click Finish to generate the report and view the results in the spreadsheet.

Related Topics

Customizing Reports with Drill-Through Wizard