Arrow Storage Products EN106 Betriebsanweisung PDF herunterladen (Seite 169)

● The Product Detail drill tab displays the results for Product Detail when you run a drill-

through report on cell D5.

Using Drill-Through

Drill-through consists of these tasks as discussed in the following topics:

● “Accessing Drill-Through Reports from the Spreadsheet” on page 169

● “Selecting Drill-Through Reports to View or Customize” on page 174

● “Selecting and Ordering Columns” on page 179

● “Ordering Data” on page 180

● “Filtering Data” on page 182

Accessing Drill-Through Reports from the Spreadsheet

Using Spreadsheet Add-in, you can access detail-level drill-through reports that are based on

the member intersections of Essbase data cells in the sheet.

Each drill-through report has been predefined by an administrator at your organization; that is,

each drill-through report is already set up to retrieve specific columns from the relational source

and to sort and filter data in these columns in specific ways. Using the Drill-Through Wizard,

you can customize these predefined drill-through reports to retrieve only the data that you want,

displayed in a specific way.

To access the predefined drill-through report, double-click a drill-through cell in the spreadsheet

(or select a range of cells and select Essbase > Linked Objects). You can set styles for cells tagged

as “drill-through” to help identify which cells in the sheet are associated with drill-through

reports.

When you double-click a drill-through cell, Essbase displays the Linked Objects Browser dialog

box, which displays a drill-through report entry. A single cell can be associated with multiple

reports. The Linked Objects Browser dialog box also displays entries for linked partitions and

other linked object types, such as cell notes, URLs, and application files.

After you view or customize the drill-through report, Integration Services retrieves data from

the relational source and displays the results in a new spreadsheet.

➤ Before starting the drill-through tutorial, perform the following tasks:

1 Open the sample Essdt.xls file.

The sample spreadsheet file contains the appropriate member intersections from the sample

database for the drill-through report. This file is provided as part of the default Essbase

installation.

2 Set a style for data cells that are associated with drill-through reports.

Using Drill-Through

169

1 2 ... 164 165 166 167 168 169 170 171 172 173 174 ... 199 200

Keine Kommentare

Arrow Storage Products EN106 Betriebsanweisung Seite 169