Arrow Storage Products EN106 Betriebsanweisung PDF herunterladen (Seite 163)

by drill-through users. If a report can be customized, you use the Drill-Through Wizard to

customize it.

The Drill-Through Wizard is a graphical user interface that steps you through the following

customization tasks:

● Selecting columns to retrieve from the relational data source

Decide which columns from the predefined report you need to see.

● Selecting the display order for columns

Change the default display order of columns across the sheet.

● Selecting a sort order for data

Select an ascending or descending sort order for a particular column; for example, sort a list

of store managers in alphabetical order.

● Selecting data filters

Define a filter on a column so that only data meeting certain criteria is retrieved.

Before You Start

Before starting the tutorial, you should have a working familiarity with the Essbase product

through the use of the Spreadsheet Add-in interface. Review in this guide Chapter 3, “Basic

Tutorial” and Chapter 4, “Advanced Tutorial” as prerequisite reading.

A sample Essbase database is the basis for the examples in this tutorial. The database

administrator creates this sample Essbase database using the sample metaoutline supplied

withIntegration Services. For information on creating the Integration Services sample

application, which includes the sample metaoutline, see the Integration Services Console online

help. A sample spreadsheet file,

Essdt.xls, contains a sheet with the appropriate member

intersections for the sample drill-through report. For more information on the sample database,

spreadsheet file, and drill-through report, see “About the Samples Used in This Tutorial” on

page 168.

If you plan to follow the examples in a live working session, check with the person at your

organization who installs theIntegration Services product family for information on the sample

database that you need for drill-through, and to which instance of Essbase Server you should

connect.

Note:

The Essdt.xls file also contains sample results of the drill-through reports when you run them

without customizing the reports. The results are provided in separate sheets in the workbook so

that you can see the sample report results without working through the tutorial. For more

information about the sample reports, see “About the Samples Used in This Tutorial” on page

168.

Before starting the tutorial, make sure you meet the following requirements:

Before You Start

163

1 2 ... 158 159 160 161 162 163 164 165 166 167 168 ... 199 200

Keine Kommentare

Arrow Storage Products EN106 Betriebsanweisung Seite 163